Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation Using "Most Current Data Entered"
I am creating an inventory sheet for my business and I'm trying to get Excel
to look through an inventory sheet, take the most recently entered inventory number, and divide it by the average daily sales to give me a "days out" number. I was going to just use an IF(D1<"",D1,IF(C1<"",C1...etc, etc but the limit to embedded IF statements struck that possibility. I figure there has to be an easier way anyway. Sheet 1 is the summary page where it has each product name, average daily sales, and then the "days out" number. Sheet 2 has each product name horizontally across the top and then the dates vertically on the left for a daily inventory count. I just can't figure out a way to get Excel to pull the most current date's inventory number. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
bunch of "yes" or "no" entered in row, output 1 if a single yes | Excel Worksheet Functions | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
How can I use the "TODAY ()" Function in an "IF/THEN" calculation | Excel Worksheet Functions | |||
=IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) |