Search results for query: *

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.

Zath, I have added the "Brackets" to my formula. However, it is still not returning the desired results. I would like the formula to return the next lowest value (that is not a zero). Thanks,

Zath, Brackets now surround my formula but it is still not returning the desired data. I would like the MIN formula to ignore all zeros and return the next lowest number?

I know there is going to be a simple formula response to this but my brain is too focused on the holidays to come up with a solution. I have a spreadsheet that contains rates in about 10 columns. I would like to add a column at the end of the spreadsheet that returns the lowest value...

Name conflicts with existing module, project or object library

I do not see my Personal.xls under Tools/References. How can I select my Personal workbook?