Search results

Asa, I appreciated the update, thank you for the kind words. However, all of you that volunteer help are the most courteous and most kind. Cheers, Persol

Mike and Asa, I celebrated too soon, I seemed to have an error that reads: "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." All I tried to do was to create the column where the array would look for the amount and...

Mike and ASA, I revisited your suggested formula, and I am extremely pleased that it worked just beautifully!!!! I apologize that I did not copy it correctly, I missed a cell reference and later it changed due to a move. Now I decided to use cell names to avoid that problem. Hey guys, thank...

Folks, I have to thank you all very much, I am not just saying it lightly, my heartfelt thank you to all of your suggested solutions and the effort invested, thank you indeed. All for the various suggestions I received made me think hard (loved it) and noted that . I used some suggestions for...

Sorry Prasad, I had missed the last part of your question. I have this schedule I am trying to finalize before I use it as a basis for a dash board. Basically, I want to be able to look at all amounts in a column (a ton of purchases made by procurement department) that would most likely have...

Prasad, I surely appreciate your help. I just tried it and the #value! message is the result, Am I missing a thing?

Hi Chandoo, hope my note finds you well. My question today has to do with something I have tried but can not find a way to resolve. I want to extract digits from a set of numbers (both negative or positive). For instance, take as an example the below set of amounts: A) $12,340.67 B)...

Hi Hui and Chandoo, great golly!!! You are awesome!! It took me a tad to come round the pics and apply as you suggested. Great help and will remain thankful. Cheers Persol

Hi Chandoo, I am curious if it would be possible to create a chart that would display a picture, symbols, or numbers instead of the numbers? I was trying to figure a way to display numbers rather than the usual bars on a graph as is shown on the following site...