I have a sheet that returns 4 numbers where 2 will match. Is there a command that will return that matching value?
For example:
cell 1 = 5
cell 2 = 9
cell 3 = 4
cell 4 = 9
something to return the value 9
Thanks
Zemmy
I have a sheet that returns 4 numbers where 2 will match. Is there a command that will return that matching value?
For example:
cell 1 = 5
cell 2 = 9
cell 3 = 4
cell 4 = 9
something to return the value 9
Thanks
Zemmy
Last edited by VBA Noob; 10-26-2008 at 04:12 PM.
If you will always have this rule you can use
=MODE(A1:A4)
where A1:A4 range contains your figures (adjust as necessary)
Bingo,
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks