gatorcc
06-26-2009, 12:25 PM
Hello,
I have a report that is generated daily that I end up having to go in and adjust about 1,700 cells to either date (mm/dd/yyyy), General or Number (#,###.##). The problem is all three of these format types are in the same column. So what I am needing help with is an IF statement that goes something like this:
If Column G has a row of text that includes *AMT* or *Balance* format column f on the same row as Number (#,###.##)
If Column G has a row of text that includes *Date* format column f on the same row as Date (mm/dd/yyyy)
If Column G has a row of text that included *CHARGE-CODE* or *Percent* format column f on the same row as General
Unfortunately the report cannot be changed so my only option is to manually make these every day.
Any suggestions would be great.
I have a report that is generated daily that I end up having to go in and adjust about 1,700 cells to either date (mm/dd/yyyy), General or Number (#,###.##). The problem is all three of these format types are in the same column. So what I am needing help with is an IF statement that goes something like this:
If Column G has a row of text that includes *AMT* or *Balance* format column f on the same row as Number (#,###.##)
If Column G has a row of text that includes *Date* format column f on the same row as Date (mm/dd/yyyy)
If Column G has a row of text that included *CHARGE-CODE* or *Percent* format column f on the same row as General
Unfortunately the report cannot be changed so my only option is to manually make these every day.
Any suggestions would be great.