If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Hi Max & Biff,
Thank you for ongoing assistance. Thanks for email attachment - will try amendments and post back in Newsgroup. Regards, Sam -- Message posted via http://www.officekb.com |
#32
|
|||
|
|||
Hi Max & Biff,
Biff's solution with the amendment using the TEXT Function worked well. Max, I am also trying your solution and thank you for creating the worksheet with the TEXT Function amendments to Biff's solution - appreciated. Thank you very much for all the help and your time. Regards, Sam -- Message posted via http://www.officekb.com |
#33
|
|||
|
|||
You're welcome, Sam !
Glad to hear you got what you wanted Thanks for the feedback .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- "Sam via OfficeKB.com" wrote in message ... Hi Max & Biff, Biff's solution with the amendment using the TEXT Function worked well. Max, I am also trying your solution and thank you for creating the worksheet with the TEXT Function amendments to Biff's solution - appreciated. Thank you very much for all the help and your time. Regards, Sam -- Message posted via http://www.officekb.com |
#34
|
|||
|
|||
.. There's a slight advantage in my suggested set-up g: It enables you
to enter the paired inputs in Sheet2's cols A and B in any order, and also the source data in Sheet1 need not be in ascending sequence [on a per row basis] as well .. And the paired inputs in Sheet2's cols A and B need not be consecutive numbers either, for example you could retrieve the results for say: 51, 79 or 73, 59 etc -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count and Sum Total occurrances of two specific numbers | Sam via OfficeKB.com | Worksheet Functions | 10 | March 29th, 2005 08:13 PM |
count a group of numbers but do not count duplicates | Lisaml | Worksheet Functions | 2 | January 26th, 2005 11:19 PM |
How do I count a range of numbers in a column | SLB | General Discussion | 3 | October 21st, 2004 05:23 PM |
Count incidences of part numbers | jmdaniel | Worksheet Functions | 13 | March 9th, 2004 05:46 PM |