![]() |
Add number from a cell that contains a specific character
I want to look in a range of cells (a1:d1) add the left number for all that
meet the criteria (a or A). I have tried variations but have yet to get it to add. A B C D 1 2 C 2 a 2 S 2 A 2 1 c 2 A 1 LS 1 C I need to leave the number and character in the same column with the space between them. |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com