Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Hello,
I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Don't quite get what you're after.
Where are the dates entered? Where is PI- entered? Maybe just editreplace what: PI- with: PI-Turbo replace all. Post a sample of a half dozen rows of your data layout. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote: Hello, I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Hi, thanks for the help. here is a sample. Customer Name Customer Location Meeting Date Product Name Ajax New York City 10/14/2005 P1 Champion New York City 1/25/2006 P3 Baker Toronto 8/23/2006 P1 Ajax New York City 4/4/2006 P1 Champion New York City 12/22/2006 P2 "Gord Dibben" wrote: Don't quite get what you're after. Where are the dates entered? Where is PI- entered? Maybe just editreplace what: PI- with: PI-Turbo replace all. Post a sample of a half dozen rows of your data layout. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote: Hello, I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Assuming Meeting Date is column C and Product Name is column D
In E2 enter this formula then copy down the column. =IF(OR(D2="",C2=""),"",D2 &"-Turbo "&TEXT(C2,"yyyy")) Gord On Sun, 21 Oct 2007 15:50:00 -0700, Ren wrote: Hi, thanks for the help. here is a sample. Customer Name Customer Location Meeting Date Product Name Ajax New York City 10/14/2005 P1 Champion New York City 1/25/2006 P3 Baker Toronto 8/23/2006 P1 Ajax New York City 4/4/2006 P1 Champion New York City 12/22/2006 P2 "Gord Dibben" wrote: Don't quite get what you're after. Where are the dates entered? Where is PI- entered? Maybe just editreplace what: PI- with: PI-Turbo replace all. Post a sample of a half dozen rows of your data layout. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote: Hello, I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Hello Ren,
I'm assuming that you want to replace PI (or is it P1, you've used both) in column D with PI-Turbo only when the date in column C is in 2006. I'm assuming that P2, P3 etc. would remain unchanged no matter what year is shown You can't change column D directly without VBA but you could use this formula in E1 copied down =IF(AND(YEAR(C1)=2006,D1="PI"),"PI-Turbo",D1) You can then replace column D with the amended data in column E. To do that, select column E, edit copy, Edit Replace values. Delete column D "Gord Dibben" wrote: Assuming Meeting Date is column C and Product Name is column D In E2 enter this formula then copy down the column. =IF(OR(D2="",C2=""),"",D2 &"-Turbo "&TEXT(C2,"yyyy")) Gord On Sun, 21 Oct 2007 15:50:00 -0700, Ren wrote: Hi, thanks for the help. here is a sample. Customer Name Customer Location Meeting Date Product Name Ajax New York City 10/14/2005 P1 Champion New York City 1/25/2006 P3 Baker Toronto 8/23/2006 P1 Ajax New York City 4/4/2006 P1 Champion New York City 12/22/2006 P2 "Gord Dibben" wrote: Don't quite get what you're after. Where are the dates entered? Where is PI- entered? Maybe just editreplace what: PI- with: PI-Turbo replace all. Post a sample of a half dozen rows of your data layout. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote: Hello, I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Error in the above, should be Edit Paste Special values
"daddylonglegs" wrote: Hello Ren, I'm assuming that you want to replace PI (or is it P1, you've used both) in column D with PI-Turbo only when the date in column C is in 2006. I'm assuming that P2, P3 etc. would remain unchanged no matter what year is shown You can't change column D directly without VBA but you could use this formula in E1 copied down =IF(AND(YEAR(C1)=2006,D1="PI"),"PI-Turbo",D1) You can then replace column D with the amended data in column E. To do that, select column E, edit copy, Edit Replace values. Delete column D "Gord Dibben" wrote: Assuming Meeting Date is column C and Product Name is column D In E2 enter this formula then copy down the column. =IF(OR(D2="",C2=""),"",D2 &"-Turbo "&TEXT(C2,"yyyy")) Gord On Sun, 21 Oct 2007 15:50:00 -0700, Ren wrote: Hi, thanks for the help. here is a sample. Customer Name Customer Location Meeting Date Product Name Ajax New York City 10/14/2005 P1 Champion New York City 1/25/2006 P3 Baker Toronto 8/23/2006 P1 Ajax New York City 4/4/2006 P1 Champion New York City 12/22/2006 P2 "Gord Dibben" wrote: Don't quite get what you're after. Where are the dates entered? Where is PI- entered? Maybe just editreplace what: PI- with: PI-Turbo replace all. Post a sample of a half dozen rows of your data layout. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote: Hello, I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date
Got it!!!!!
Thanks so much : ) "daddylonglegs" wrote: Error in the above, should be Edit Paste Special values "daddylonglegs" wrote: Hello Ren, I'm assuming that you want to replace PI (or is it P1, you've used both) in column D with PI-Turbo only when the date in column C is in 2006. I'm assuming that P2, P3 etc. would remain unchanged no matter what year is shown You can't change column D directly without VBA but you could use this formula in E1 copied down =IF(AND(YEAR(C1)=2006,D1="PI"),"PI-Turbo",D1) You can then replace column D with the amended data in column E. To do that, select column E, edit copy, Edit Replace values. Delete column D "Gord Dibben" wrote: Assuming Meeting Date is column C and Product Name is column D In E2 enter this formula then copy down the column. =IF(OR(D2="",C2=""),"",D2 &"-Turbo "&TEXT(C2,"yyyy")) Gord On Sun, 21 Oct 2007 15:50:00 -0700, Ren wrote: Hi, thanks for the help. here is a sample. Customer Name Customer Location Meeting Date Product Name Ajax New York City 10/14/2005 P1 Champion New York City 1/25/2006 P3 Baker Toronto 8/23/2006 P1 Ajax New York City 4/4/2006 P1 Champion New York City 12/22/2006 P2 "Gord Dibben" wrote: Don't quite get what you're after. Where are the dates entered? Where is PI- entered? Maybe just editreplace what: PI- with: PI-Turbo replace all. Post a sample of a half dozen rows of your data layout. Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 14:54:01 -0700, Ren wrote: Hello, I am doing a little assignment for school. I have a product name P1- and I have sold it during 2 years: 2005 and 2006. All of those sales with different months and days. The name needs to be change- it is renamed P1-Turbo in 2006 How can I do that? Can I use an IF function? If so, how can I input the date if the data contains different days and months??? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |