Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2011, 06:24 AM
Jamal NUMAN Jamal NUMAN is offline How to get the inverse of the values in the same table? Windows XP How to get the inverse of the values in the same table? Office 2007
Expert
How to get the inverse of the values in the same table?
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Thumbs up

appreciated Paul. it did work



regards

Jamal




Quote:
Originally Posted by macropod View Post
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.
Attached Images
File Type: jpg solutionClip.jpg (100.9 KB, 11 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get the inverse of the values in the same table? comparing values from a range struct Excel 1 04-01-2011 07:17 PM
Calendar control accepts other values JeJ Word 0 03-02-2011 03:38 PM
How to get the inverse of the values in the same table? help with formulate refers to values meninio Excel 11 01-26-2011 10:00 AM
How to get the inverse of the values in the same table? Using Conditions to Add Values EclipticalD Excel 1 07-08-2010 09:50 PM
Opening .pst with dummy values ran_sushmi Outlook 0 08-19-2009 01:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft