Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing
Greetings,
I need some help with the following. What formula do I use in Column D if I want to get the values in column C for those items which has a the word freight in Column A ? Please refer to the data below. Column A Column B Column C PLP AIR FREIGHT RECOVERY 7/08/2009 0.00 AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00 AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00 WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20 PLP AIR FREIGHT RECOVERY 18/08/2009 444.53 TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 Cheers!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing
In D2: =IF(COUNTIF(A2,"*FREIGHT*"),C2,"")
copy down "5F80YZ" wrote: Greetings, I need some help with the following. What formula do I use in Column D if I want to get the values in column C for those items which has a the word freight in Column A ? Please refer to the data below. Column A Column B Column C PLP AIR FREIGHT RECOVERY 7/08/2009 0.00 AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00 AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00 WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20 PLP AIR FREIGHT RECOVERY 18/08/2009 444.53 TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 Cheers!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing
While using the same logic elsewhere with a different search string you can
try the below formula with spaces padded before and after the text string so as to have a ** full word ** match. =IF(ISNUMBER(SEARCH(" FREIGHT "," " & A1 & " ")),C1,"") If this post helps click Yes --------------- Jacob Skaria "5F80YZ" wrote: Greetings, I need some help with the following. What formula do I use in Column D if I want to get the values in column C for those items which has a the word freight in Column A ? Please refer to the data below. Column A Column B Column C PLP AIR FREIGHT RECOVERY 7/08/2009 0.00 AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00 AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00 WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20 PLP AIR FREIGHT RECOVERY 18/08/2009 444.53 TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 Cheers!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing
Man, you guys are legends!!
Thanks heaps!! "Jacob Skaria" wrote: While using the same logic elsewhere with a different search string you can try the below formula with spaces padded before and after the text string so as to have a ** full word ** match. =IF(ISNUMBER(SEARCH(" FREIGHT "," " & A1 & " ")),C1,"") If this post helps click Yes --------------- Jacob Skaria "5F80YZ" wrote: Greetings, I need some help with the following. What formula do I use in Column D if I want to get the values in column C for those items which has a the word freight in Column A ? Please refer to the data below. Column A Column B Column C PLP AIR FREIGHT RECOVERY 7/08/2009 0.00 AL CLEVIS THIMBLE 37MM GROOVE 17/08/2009 -490.00 AL CLEVIS THIMBLE 37MM GROOVE 14/08/2009 1,176.00 WIRE ROPE OPEN THIMBLE 20MM DIA 14/08/2009 543.20 PLP AIR FREIGHT RECOVERY 18/08/2009 444.53 TIE DIST 22.60-24.59MM OVER ARMOUR 20/08/2009 1,963.20 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 PLP FREIGHT & HANDLING CHARGES 25/08/2009 272.50 Cheers!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing | Excel Discussion (Misc queries) | |||
referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
More referencing | Excel Worksheet Functions | |||
referencing | New Users to Excel | |||
referencing | Excel Worksheet Functions |