How to get the inverse of the values in the same table?

Jamal NUMAN · #1 04-16-2011, 06:24 AM

appreciated Paul. it did work

regards

Jamal

Quote:

Originally Posted by macropod

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
help with formulate refers to values	meninio	Excel	11	01-26-2011 10:00 AM
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