Hi, I use Lotus Notes as email and have set up a macro in Excel using the information from XL-Dennis on VSTO /.Net & Excel to create my email macro and have...

Hi Any help I have a cell resulting from an IF function, the result is either a number or blank (“”). I want to write If function in the next cell...

Dear all I have in cell H14 = A AND I14= FALSE, J14=FALSE, K14=FALSE IN H15=FALSE I15=B, J15=FALSE, K15=FALSE IN H16=FALSE I16=FALSE J16=C, K16=FALSE So i...

hey im using the following code and days and mids are are showing up as #N/A thanks for any help you can give...

I have a number of spreadsheets that I need to find the sum of two columns that occur during a date period. I want to know the sum for 1 pump & 2 pump for...

I need to get exact match with function like LOOKUP in EXCEL.

i would like excel to automatically generate unique reciept /invoice numbers which i are sequencial. i can then pass word lock. i do not have Access on my...

Hello, I have data below, On D1 if I put the formula =AVERAGE(A1:C1) it will return 80; the input data are A1 to C1 A B C D 1...

I have a cells that I need to input GBP to USD and HKD to USD exchange rates and I need for the information to refresh without me having to change the...

Hi, (Again). Thanks for your help and patience by the way! I copied it in exactly as described and it came up with a Compile error: Block If without End...

I'm trying to figure out how I can easily match a list of numbers into a set category. For example. I have the number 11. I have the categories 1-10, 11-19,...

Column A has some numbers in it, Column B has some numbers in it, and Column C=A*B respectivily. At the bottom of column C is the Min, Max ,and Average...

I am trying to do a function that will look for and tell me if there is or is not a duplicate number on a spread sheet. EX: column B has numbers in accending...

I have a spreadsheet with the following information: Active? Type Y GI N AD Y AD N GI I need to count how many AD with Y are in the...

This seems so simple, but I need divide a value by the day360 formula. I entered =(H12-H14)/DAYS360(G13,G11) i get back 10/24/1908 thanks

I need to calculate percentage rent owed when their are multiple percentage rent rates with different breakpoints. The formula below returns "False" if...

i want to check if any or all the cells a2:a5 are blank i have tried IF((A2 or A3=""),B1,"") & IF((A2 AND A3=""),B1,"") this returns NAME and...

I am trying to use auto filter with the "countif" function? This Formula gives me a percent for the hole...

I am trying to use auto filter with the "countif" function? This Formula gives me a percent for the hole...

On one sheet, I would like to have a list of names (travelers in my case) which I would assume I would need to define as a group. I would like the first...