Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas with Counters
How do I place a formula in a cell while using a counter? Here's an example of a formula that I want to use: LEFT(OFFSET($A$27,(ROW($C1)-1)*14,0),LEN(OFFSET($A$27,(ROW($C1)-1)*14,0))-8 In addition, I want to place the same formula in the same column (as an example Column C). Therefore, Cell $C1 will change to $C2 and so on. I want to place the original formula in Cell C1 and then C2... I need to use a counter to tell the program when to stop. How do I do this? Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with Counters | Excel Discussion (Misc queries) | |||
INVOICE COUNTERS | Excel Worksheet Functions | |||
INVOICE COUNTERS | Excel Worksheet Functions | |||
Counters | Excel Worksheet Functions | |||
counters | Excel Programming |