experts

Hello, all, Attached is StartOver02.xlsx. I'd like to convert the appearance of column D to the appearance of column E, the one with reversed colors in the column's title. More specifically, I want only the total number of sales per day to appear, with the previous cells for that day in that...

I have a MS Excel formula in a cell that I'd like to convert to VBA in order to use in MS Access. Would one you experts be so kind as to convert this formula into a VBA function. =LEN(SUBSTITUTE(C3, " ", "")) Thank you so much.

Dear All Excel Experts I have my sheets: Clients, Payments, Statement In the Statement sheet I tried my best that Excel automatically looks for the payment of the client and decides "Paid" or "Unpaid", but in vain. I have hope that experts will help my solve this problem. By the way the payment...

Hi all you experts out there, I have a load of info regarding accident at work Ideally I would like to use the info in a pivot table, having never created one I really need advise. Can anyone spare the time to create one so that I can show areas, times etc so that I can just show a slide...

Hello everyone So I wanted to use a INDEX-MATCH-MAX statement in order to find the highest number within a row then use INDEX to place the name linked to that number within that row. This worked well, but now I want to merge it with a IF statement and dont know how to. This is why I come to you...

Hi Guys I have set up a dropdown box that allows me to select for 4 criteria-Construction, age, size,condition ( see Yellow coloured headings). Under the heading-Construction there are four selections- Double Brick, Brick Veneer,Weatherboard,Asbestos Cement. The selection that I have made from...

Hi Friends, I got some boring task from office. I have to do it everyday. So knowing the strength of excel I am looking for a solution so that I can make this task easier by the help of excel experts like you. [/IMG] Note: Source and output will be on same workbook and different sheets. I know...