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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using wild card in IF formula
Try this:
=IF(ISNUMBER(SEARCH("total",A3)),B3,"") Search is not case sensitive - you can use FIND if that is important to you. Hope this helps. Pete On Sep 18, 9:54*pm, gcukarski wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using wild card in IF formula
Try
=IF(ISERROR(FIND("Total",E19)),"",B3) This will not match Total but will match total "gcukarski" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using wild card in IF formula
One more that uses wildcards:
=if(countif(a3,"*total*")0,b3,"") gcukarski wrote: 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. -- Dave Peterson |
Reply |
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 |