Ask Experts & Get Answers to Your Questions - ASAP
IHave an excel file I would like to upload to you.
Please provide instructions for me to submit the excel file
It would probably be easiest to create a google shared doc account and make the spreadsheet public and let me take a look at it.
Otherwise you could try creating an account with mediafire, though the product is very spammy and not as reliable.
The formula error is in Cell V47.
The formula should react the same as the formula in cell V48.
Please correct the formula in Cell v47.
Thanks as I wait for your answer,
I went ahead and moved your sum columns over to the left side so that you can use a vlookup instead of just regular lookup. It is a bit more flexible in that I just reference the entire column range.
It appears the second formula refers to weekend values whereas the first formula refers to weekdays.
I've gotten it to work in the spreadsheet fine, but when I load it into google docs, there is an error about finding 9.99999900000
I noticed one of the items it references is a match formula with some real odd reference. What exactly is the purpose of that?Also, what version do you use? I can save as xlsx or 97-2003 version
You can send it in Excel 2010.
The layout can not change & I am not sure of the reference match you refer to.
I believe the conflict occurring is in cell v52, formula reads
The index function typically wants to refer to a specific row/column
However, for the row parameter it has that odd MATCH function.
It would be nice to know what the purpose of that index formula is.
Do you basically just want to have that value be whatever the most current row/date is with a value in column D is? That would be my guess, without knowing for sure.
Yes; I want the most current date in that collum.
So; maybe you can provide a more practicle formula for that cell.
Ultimately, cell V51 should be the most recent date corresponding to the row when a value is in either Colum D or E. In this case the answer in V51 should be Aptil 15, 2011.
If, however the last row containing values was row 14, the answer in V51 would be
April 11, 2011.
Therefore, the formulas in v47,v48, v52 & v53 become irrelevant.
Maybe this shows my inexperience with formulas.
Thank you for your help!
I tested the formula in another file which had the same value in two rows in the same column.
How would you modify the formula to identify the most recent date under those circumstances?