I need you Mike H!
Mike,
The formula you wrote works Great in the example, but not in my workbook!!! I have trying formatting the columns to assure they are all text, with still no luck! May I email you my workbook? I've trimmed it down to only 3 rows on 2 sheets. Please let me know! Thanks, Jess |
I need you Mike H!
What result do you get?
"jessshouse" wrote: Mike, The formula you wrote works Great in the example, but not in my workbook!!! I have trying formatting the columns to assure they are all text, with still no luck! May I email you my workbook? I've trimmed it down to only 3 rows on 2 sheets. Please let me know! Thanks, Jess |
I need you Mike H!
Further, if data is text, you may extra blanks at front/end of text which
will cause a mismatch. Look at TRIM function to remove these. "jessshouse" wrote: Mike, The formula you wrote works Great in the example, but not in my workbook!!! I have trying formatting the columns to assure they are all text, with still no luck! May I email you my workbook? I've trimmed it down to only 3 rows on 2 sheets. Please let me know! Thanks, Jess |
I need you Mike H!
Toppers!!! That was it!!! Thank you so much!
"Toppers" wrote: What result do you get? "jessshouse" wrote: Mike, The formula you wrote works Great in the example, but not in my workbook!!! I have trying formatting the columns to assure they are all text, with still no luck! May I email you my workbook? I've trimmed it down to only 3 rows on 2 sheets. Please let me know! Thanks, Jess |
I need you Mike H!
This may be good reading for you
http://dts-l.org/goodpost.htm -- Don Guillett SalesAid Software "jessshouse" wrote in message ... Mike, The formula you wrote works Great in the example, but not in my workbook!!! I have trying formatting the columns to assure they are all text, with still no luck! May I email you my workbook? I've trimmed it down to only 3 rows on 2 sheets. Please let me know! Thanks, Jess |
All times are GMT +1. The time now is 06:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com