Recent content by Cordury

I apologize that I was not clear. I was curious is an the Array function could separate the data in the format that I need.

If someone could let me know how to post a pic/image of the actual report, I will do it. The original post does not look very good.

I receive daily invoice paid/process reports from a third party vendor, so there is little hope that they will change the format of their files. I simply would like to read the .txt files in Excel. When I copy and paste the data, and use the Text to Columns function, there are serious format...

Thanks, I was close :)

=IF(ISERROR(VLOOKUP(C1,A1:A6,1,0)),C1*0.56,C1) Would that work?

Thanks Blue. However, I did not post the proper. I have a column of numbers, and if the value is not 500 400 300 200 180 150 I just want to return the value in the cell. If it is one of the above values, I would like to muliply it by .56 Thanks, Cord

I have a set of 6 numbers: 500 400 300 200 180 150 If a cell equals any of the above numbers I want the cell value to be multipled by .56 if else, multiply the cell value by .185 I am having issues with the embedded is statement. Should I add another column and try using a lookup (using a...

Thank you Ken. Will the type save in the properties box?

Do you receive the same error if you already have your datasheet open and then open your Word Mail Merge doc?

One more thing, will Excel save the format (in XLSTART) for future use ?

First let me start off by posting, I'm an idiot. All I want to do is create a custom format that leaves positive percentages black and formats negative percentages with ()'s and formats the font red. The current type #,##0.0_%);[Red](#,##0.0%) Is not working for the postive numbers. Thanks...

Ken, Columns AO,AJ,AE,Z,U,P,K contain an internal company metric. Your formula will pull the lowest value (greater than zero) from columns other than AO,AJ,AE,Z,U,P,K. I apologize if I am doing a poor job explaning my issue. Your formula =IF(MAX(AO3,AJ3,AE3,Z3,U3,P3,K3)=0,"NO...

Ken, Your formula is working (sort of). It is pulling data from columns that I do not want it to pull from. I was hoping to return the lowest value (excluding zero) from $AO3,$AJ3,$AE3,$Z3,$U3,$P3,$K3 Thanks, Cord

I understand why most of your suggestion works, however- Why is the reasoning behind adding 1 to the count of zeros in the last formula? After the above formula (to the right), enter this formula: =SMALL((AO4,AJ4,AE4,Z4,U4,P4,K4),BF4+1)

Dale, Thanks for taking the time to explain the different forumlas. Yes it is a bire more lengthy than I would have liked but Hey- it works the same. Again, thanks for taking the time.