| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display the cell value in the next 33rd cell
I need some help with writing a 'search & display' formula:
Scenario: cell A9 has a value of $4600 - set cell T2 to '=A9' Question: what formula do I put in T3 if I want it to return the value in cell A42 (basically, every 33rd cell from a range of cells). This is for a monthly report where the starting cell is not always 'A9', and the locations of the 'next 33rd cell' varies from month to month... thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display the cell it goes to at the centre of the monitor screen? | Excel Discussion (Misc queries) | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
| Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
Threaded Mode
