LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 51
Default Count duplicate cell values per month

Hi experts

I need to look down column Q, R, S and T and find duplicate values for the
same month and in a new cell just put a number of times they are duplicated
on the same row

ill explain, i.e.

Q R S T
Part 1 Part 2 Part3 Part 4
30.00 30.00 0.00 0.00

So in rows Q - T 30.00 appers twice, so id like cell U e.g. to report the
number 2

I hope that makes sense

Thanks

Derek
 
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
Warning while entering duplicate values in a cell Raj Mazumdar Excel Discussion (Misc queries) 2 February 28th 06 11:05 PM
Why do my cell values/words duplicate themselves over and over? stevow84 Excel Discussion (Misc queries) 1 January 31st 06 09:44 PM
Preventing user entering duplicate values in a cell range Thomas Peters Excel Worksheet Functions 1 November 30th 05 08:00 PM
Count on multiple values with duplicate rows Carla Excel Worksheet Functions 1 November 22nd 05 09:25 PM
How do I do count calculations ignoring duplicate values Robin Faulkner Excel Discussion (Misc queries) 1 March 31st 05 03:01 PM


All times are GMT +1. The time now is 06:36 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"