Invert

[Wayne Burritt]

Hi--I have a column of numbers for A1:A40 that I simply need to invert. Any
suggestions? Wayne

 

[Anders S]

One way is to

- insert a temporary column A
- autofill column A with the numbers 1 - 40
- sort descending on column A
- delete column A

HTH
Anders Silvén

 

[Anders S]

Harlan,

As you can see in my reply, I read the question as how turn the table upside
down, not how to get the inverse of the numbers. Probably a language thing (for
me).

However, the trick to get the array into the formula bar, I have not seen
before. Nice!

Best regards
Anders Silvén

Hi--I have a column of numbers for A1:A40 that I simply need to invert. Any
suggestions? Wayne

Since your range is small, select A1:A40, type the formula =1/A1:A40, *DON'T*
press [Enter] but instead press [F9]. This should give you an array of the
inverses in the formula bar. Hold down [Ctrl] and [Shift] keys and press
[Enter], then (optionally) Edit > Copy, Edit > Paste-Special as values.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.