Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need formula modification help
Ok l will post data table tonight. Thank you wery much for your explanation. Im relatively new to excel and not familiar enough with all details of its terms. Terribly sorry for confusion. And one more time very big thank you.- sergiy123
- Post #8
- Forum: Microsoft: Office
-
Need formula modification help
Hi. There is no table, just data list. Data presented in form of numbers,where column A has no empty cells, but columns b,c,d can have some cells empty. Column A without empty cells permits to the formula to operate as intended. Empty entries in other columns are posted to the new location as...- sergiy123
- Post #5
- Forum: Microsoft: Office
-
Need formula modification help
Data list unfortunately can have empty cells. Yes lm referencing to the sells.Some of these can be empty. The cells lm referencing to can have empty entries, where value is unknown or not present. It makes target sells display value of zero, that unfortunately is value by itself in posterior...- sergiy123
- Post #3
- Forum: Microsoft: Office
-
Need formula modification help
Hi, everybody. I found formula l needed to automate copy/paste of last 10 rows in data list to new location. The tread im referencing to thread68-703675. The formula, im speaking about is =OFFSET(Sheet1!A1,MAX((NOT(ISBLANK(Sheet1!A1:A1000)))*ROW(Sheet1!A1:A1000))-10,,10,4). This formula have...- sergiy123
- Thread
- Replies: 8
- Forum: Microsoft: Office
