| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to reference range based on data in column
I probably didn't title this too well.
I have a spreadsheet with 500 rows of data, sorted by the date in column A. I want to extract certain data from rows that all start with the same specified date. Previously I used an IF formula but that necessitates having the formula in 500 rows which won't work for my purposes. I'm going round incircles trying to think how best to achieve this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel - changing reference column value based on another column | Excel Discussion (Misc queries) | |||
| Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
| Sort a range of data based on another column | Excel Discussion (Misc queries) | |||
| Reference Data Range based on cell contents | Charts and Charting in Excel | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
