appreciated

I had Excel Launcer installed but it was inadvertenly removed. My search has revealed I need ConsoleApplication1.exe to assist with installation , but I am unsure of where to locate it. Am able to open .xls files but not .xlsm , so any assistance with ConsoleApplication1.exe would be...

Hi Folks, I think this is quite an easy one - I've seen similar solutions through searching but not quite exactly this. I have a column with data in it and I want to use vba to get rid of everything before - and including # So for instance I've got ZP02-TS-GLE#1282255 and I want to get rid of...

Hi Everyone, I'm trying to replace these bolded numbers... =SUMPRODUCT(1/COUNTIF('Monthly Bills Rec''d'!F2:F5000,'Monthly Bills Rec''d'!F2:F5000)) With the COUNTA result from this formula... COUNTA('Monthly Bills Rec''d'!A:A) Any help on how to do this would be greatly appreciated. Thanks.

I have a very long column going from C1 to C1832 and would like to convert it into 4 rows of 458 values. I am not sure how to do this and any help is appreciated. An example of what I am trying to do is if I have the following values in my column 4 5 6 7 1 2 3 4 I want to create rows of 4 5...

I'm getting an error 'Expected =' and I'm not sure why. This is the line it didn't like. Sheets(1).copy(after:=Workbooks("Report").Worksheets(Workbooks("Report").Worksheets.Count)) I'm trying to copy a sheet to a different wordbook. Any help with the error would be appreciated. Thanks

Hello, I’m trying to figure out a formula which will search a sheet for a phrase and then display the number which will be two cells below? Any help would be appreciated Thanks

Good afternoon, by racking my tiny brains on this one as to whether it is actually possible with such little knowledge I have, although a fast(ish) learner. I tried pivot tables but could only get on row of data to pull in. The data I have is employee payments and deductions by date listed down...

I want to use this formula in VBA. Any assistance is appreciated. Thanks =SUMPRODUCT(SUBTOTAL(9,OFFSET(P15,ROW(P15:P427)-ROW(P15),0,1)),--(P15:P427 < 0))

I have tried the basic 'Data' then select 'Consolidate' then 'Sum' etc.....looking for some help to sum up the QTY and SYM and get rid of the dups...I have attached (2) images...the 'Before' and what I'm looking to accomplish with the 'After'...any help with this would be very much appreciated...

Hi all I have the following formula =IF(P44>5,"",1) which is looking up a formula in cell P44 of =WEEKDAY(O40,2). Now when i get a #VALUE error I have tried to use the formula =IF(ISERROR((P44>5,"",1)),"", 1) but i get a message box saying "There's a problem with this formula Not trying to...

Hi, I am looking to use CF to show how many working days have passed from TODAY RED - 3 or more ORANGE - 2 YELLOW - 1 GREEN - TODAY Any help appreciated Thanks

Hi, I am really new in htlm coding, how can I ghe ID tag of loging boxes for website when there's no id= and the name is hidden. some the websites are easier to find them as will have like id=username etc but some them no how can find those, much appreciated your help. thank you.

I have tried to apply CF to use fill color Blue to Highlight Col A:C where "Total Sales WIP" appears in Col A It would be appreciated if someone could assist me, by providing the steps to do this

I am doing a sum formula and need some help on rounding. One of my examples: 77.8 (shows as 78) minus 82.5 = -4.7 How do I get it to show a total of 4.5? Because in reality 78 - 82.5 = -4.5 Another one: 109.1 (shows as 109) minus 95.5 = 13.6 but I really need it to say 13.5 Any help...

Hello All, I have a large spreadsheet which I am working off (20+K rows) The following is a formula which I wrote, but when I fill down, it takes a long time to process, so just wondering if there is a way to simplify it. Any help would be greatly appreciated. =IF(A1="",""...

Hi I’ve got a column of numbers starting in N4 for example 7 1 25 22 34 30 In the next column starting in O4, i’d like to place them in ascending order 1 7 22 25 30 34 I can’t work out how to do this. Any help is very much appreciated. Regards

trying to an IF function along with a MID in extracting numberswithing a string of both text and numbers.<o:p></o:p> PBQ4X5 - using =MID(A2, SEARCH("Q",A2)+1, 1) to returnthe "4" and the same with "X" to return the numberassociated with it. Unfortunately when it runs across a sequence that...

Hi all, I am trying to modify the following formula to have the CF show when the date in M13 is within 10 working days of (Today) =AND(LEN($M13),TODAY()+3=$M13) Any help appreciated Thanks

Hello - I want to write a formula to do the following: If F3 has a number in it than tell me if M3 is blank. <colgroup><col width="72"></colgroup><tbody> </tbody> in other words... you have to be doing the criteria we have in one column if you want to sell the product in the other...

I have been beating away at this keybod for hours and i am stuck trying to convert my gps coordinates to another format. Can someone help with this? here is what I am trying to do: Cell A Cell B N 34 37.760,W 84 11.565 ----->...