Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Adjustment - Help
I am trying to adjust the following formula to only show specific records
from the linking worksheet: =IF(OFFSET('Master List (Update)'!$F$2,(ROW()-2)/13,0)<"",OFFSET('Master List (Update)'!$F$2,(ROW()-2)/13,0),"") The formula shows for instance in 'Worksheet 1' A3 the data from the 'Master List (Update)' F2...Then in 'Worksheet 1' A16 will show the data from Master List (Update)' F3...then in 'Worksheet 1' A29 will show the data from 'Master List (Update)' F4...and so on. I would like to make it so that when I filter 'Master List (Update)', only the filtered records data shows in worksheet 1. For example: If only row 2 & 4 show in the 'Master List (Update)' worksheet, then 'Worksheet 1' A3 would show 'Master List (Update)' F2...and 'Worksheet 1' A16 would show 'Master List (Update)' F4... Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Adjustment - Help
Thought maybe a little more explaination might help.
The setup is a "printable form" to reorganize the data. 'Worksheet 1' A3 is the address field of the Report/Form for Customer 1...then A16 is same field for customer 2 and so on. "Josh O." wrote: I am trying to adjust the following formula to only show specific records from the linking worksheet: =IF(OFFSET('Master List (Update)'!$F$2,(ROW()-2)/13,0)<"",OFFSET('Master List (Update)'!$F$2,(ROW()-2)/13,0),"") The formula shows for instance in 'Worksheet 1' A3 the data from the 'Master List (Update)' F2...Then in 'Worksheet 1' A16 will show the data from Master List (Update)' F3...then in 'Worksheet 1' A29 will show the data from 'Master List (Update)' F4...and so on. I would like to make it so that when I filter 'Master List (Update)', only the filtered records data shows in worksheet 1. For example: If only row 2 & 4 show in the 'Master List (Update)' worksheet, then 'Worksheet 1' A3 would show 'Master List (Update)' F2...and 'Worksheet 1' A16 would show 'Master List (Update)' F4... Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |