Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using wild card in IF formula
I have a list of names in Column A with values in Column B
A B George 2 George 3 George Total 5 Adam 5 Adam 6 Adam 7 Adam Total 18 I need an IF formula in Column C that will look for cells in Column A that have the word "total" in them. This is what I've tried and it doesnt work: =IF(A3="*total*", B3, "") Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wild card in sumproduct | Excel Worksheet Functions | |||
Wild card in two condition text formula | Excel Discussion (Misc queries) | |||
wild card -- help with formula | Excel Discussion (Misc queries) | |||
Wild card * | Excel Worksheet Functions | |||
Wild Card and Dates | Excel Worksheet Functions |