Get instant live expert help on n/a meaning
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
the meaning of lock the file and protect the file
Solved by K. J. in 24 mins
Hi, I need a formula to work out how many values are less than a certain time value, simple "countif" do not work as it is a filtered spreadsheet.
Here's the formula that I have got so far:
SUMPRODUCT(SUBTOTAL(3,OFFSET(Current_Month!N$2:N$10000,ROW(Current_Month!N$2:N$10000)-MIN(ROW(Current_Month!N$2:N$10000)),,1)),--(Current_Month!N$2:N$10000>"24:0:0")
Solved by K. L. in 26 mins
Qty Part Number Description Price Total Subtotal: #N/A
1 3009 ALFALFA, LEAF, Powder $3.05 3.05 Tax: #N/A
Total Order: #N/A
Qty Part Number Description Price Total Subtotal: #N/A
1 AFRICAN BIRD PEPPER, FRUIT, Whole #N/A #N/A Tax: #N/A
Total Order: #N/A
I want the formula to read as the second part
Solved by B. H. in 18 mins
meaning of this formula =INDEX(Form22!$B:$B,(((ROW()-23)/37+1)+15)) in excel
Solved by I. J. in 23 mins
I have a list of numbers in column A. In column B I am putting either a 1 or a 0 next to the numbers in column a that I want to choose. 1 meaning choose and 0 meaning dont choose. In column C I want the Chosen column A numbers to file down in order
Solved by A. Q. in 28 mins