Remember Me?

#31
April 3rd 05, 05:00 PM
 Sam via OfficeKB.com Posts: n/a

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
April 3rd 05, 06:29 PM
 Sam via OfficeKB.com Posts: n/a

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
April 3rd 05, 11:20 PM
 Max Posts: n/a

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 <atyahoo<dotcom
----
"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
April 4th 05, 02:17 PM
 Max Posts: n/a

.. 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 <atyahoo<dotcom
----

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM Marsha Excel Discussion (Misc queries) 5 March 7th 05 05:49 PM Alex Excel Worksheet Functions 1 February 21st 05 07:46 PM Sam via OfficeKB.com Excel Worksheet Functions 5 February 19th 05 02:49 AM Lisaml Excel Worksheet Functions 2 January 26th 05 11:19 PM

All times are GMT +1. The time now is 05:01 AM.