Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling Information
I actually have two questions,
I have a spreadsheet with rolling data- everytime I insert a new line the top line is deleted. At the bottom of the sheet I want to pull all the information that contains the letters PD 10 into a little table of it's own. I used the Advanced Filter to do this and recorded a marco to update the filter and repopulate the table, but it gets messed up because of the rolling info. Is there a better way to do this? Second question concerns Offset - I have had to use offset in everything I have done. How do mix the two equations =IF(OR((LEN(B27)=10),(LEFT(B27,4)="PD 5")),H27,NA()) and an offset equation to keep this equation in place? -- Thanks, Nikki |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling Information
I just wanted to say I figured it out-
-- Thanks, Nikki "Nikki" wrote: I actually have two questions, I have a spreadsheet with rolling data- everytime I insert a new line the top line is deleted. At the bottom of the sheet I want to pull all the information that contains the letters PD 10 into a little table of it's own. I used the Advanced Filter to do this and recorded a marco to update the filter and repopulate the table, but it gets messed up because of the rolling info. Is there a better way to do this? Second question concerns Offset - I have had to use offset in everything I have done. How do mix the two equations =IF(OR((LEN(B27)=10),(LEFT(B27,4)="PD 5")),H27,NA()) and an offset equation to keep this equation in place? -- Thanks, Nikki |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions |