Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default existing unique value formula help (index(match(countif)))

It's likely that the numbers in Column E are being recognized as text.
Try the following...

1) Select an empty cell

2) Edit Copy

3) Select Column E

4) Edit Paste Special Add Ok

Does this help?

In article . com,
wrote:

okay i'm not getting an error message anymore, but it's not bringing up
the right information. the formula is bringing up values from "d" with
zeros in "e"; it misses values from d with positive values in "e" and
finally, when you delete one from the top of the list, the rest of the
cloumn should adjust, but it isn't... any clues? if not it's okay, it's
not that much manual work, the original formula is a big help for me
though. thanks again.
jason

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Match formula that pulls unique values from another column? alehm Excel Discussion (Misc queries) 6 September 8th 05 10:38 PM
What is the formula for adding a number of days to an existing dat Ivan Excel Worksheet Functions 1 May 4th 05 03:00 AM
insert a new cell into an existing formula Debbie Excel Discussion (Misc queries) 3 March 14th 05 06:46 PM
Modifying an Existing Formula carl Excel Worksheet Functions 1 December 31st 04 04:55 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"