| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
populate backwards
Hi All,
I have two columns one: A1 value 100,A2 value 201,A3 value 33. I need to put in B1 the value of A3, B2- A2,B3-A1. Is there a way to acomplish that with the help of a formula? Thanks a lot in advance, Assaf |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
populate backwards
Hi Assaf
Try: =INDEX($A$1:$A$3,ROWS($B1:$B$3)) copied down. Hope this helps! Richard Lp12 wrote: Hi All, I have two columns one: A1 value 100,A2 value 201,A3 value 33. I need to put in B1 the value of A3, B2- A2,B3-A1. Is there a way to acomplish that with the help of a formula? Thanks a lot in advance, Assaf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| Populate a combo Box | Excel Worksheet Functions | |||
| REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
| getting multiple data to populate another worksheet | Excel Worksheet Functions | |||
| How to populate column with formula based on value in cell | Excel Worksheet Functions | |||
Linear Mode
