Thread: [Solved] How to get the inverse of the values in the same table?
View Single Post
 
Old 04-16-2011, 06:09 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Jamal,

That is not the same spreadsheet that was attached to your other post. Neither does it have the formula I posted in it.

Naturally, since the layout is different, it would be unreasonable to expect a formula designed for a different layout to work with this one. If you delete Column A from the second workbook you posted, then the formula I gave you will work.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote