Functions

Macro Help
I am very new to Macro's but am hoping you can simplify your response I have a sheet that contains certain data types in specific columns For example Column A = Date B= Name C=Description D=Cheque# E= Account # (Debits) F = Debit amount G = Account # (Credits) H= Credit Amount I need to write a Ma... 16 Mar 2010 05:46

If Vlookup is error ( #NA)
I have this formula =IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)>0,(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"") that is producing #NA if it doesn't find C3. I would instead like the result to be blank "" when it produces an #NA Thanks, Steve ... 16 Mar 2010 12:33

EXCEL COUNTING HELP
I need to count the number of occurances of a date range from a column of dates spanning from December 1, 2009 - March 15, 2010. (how many dates in column C are in the month of december 2009). How do i write a formula that will recogize the date? thanks ... 15 Mar 2010 18:11

how to sum cells and ignore the #div/0! 's ?
I an working with the following formula: =SUM(C8:E8)/COUNTIF(C8:E8,">0") if I initially have no data entered i get the #div/0! 's is there a fix for this? ... 15 Mar 2010 15:51

Counting independent items in a list
This formula is meant to count independent entries in A1:A20. =ROUND(SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20)),0) Can anyone make this better? I am not talking about using Absolute references, but ways to modify it so it works in every case. For instance, at first I had an empty cell in my range and the #DIV/0 e... 15 Mar 2010 15:51

Dynamically Adding Textbox To Frame
How do I add a textbox control to a frame object (declared as OLEObject) in vba code behind a worksheet? For example, I have tried the following that doesn't work... Dim objFrame As OleObject Set objFrame = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Frame.1") With objFrame .Object.Controls.Add ClassT... 15 Mar 2010 14:39

Cells Fill Automatically on Another Workbook
I've created what we'll call a seed worksheet to be used over and over for different clients. I have linked its cells to another workbook. As the originating seed worksheet directs its cell data to a specific cell on another workbook, how can I accomplish the workbook data not being overwritten but the new inco... 15 Mar 2010 12:21

Index/Lookup Function?
Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding sales reps until i run out. I am not sure which formula is best: Index, Lookup etc. A B manager 1 sales rep 1 manager 1 sal... 15 Mar 2010 19:30

List top five
Hi there, I've searched this site looking for an answer for this but no luck What I have is imported list of invoices thousands of rows long with about 450 suppliers occurring many times over. What I want is a formula or function that will give me the top 5 suppliers - something like (MAX(Count,1 ,2, ,3...?? ... 16 Mar 2010 10:16

Sharing Violation
After I create a new Excel file, and then try to make changes to it, I get a message that says I can't save it because it's a "sharing violation". Could anyone help me with this? Carolan ... 18 Mar 2010 13:01