appreciated

I have a mixture of formulas and text in Col H I would like to set up a formula in Col I, that if there is formula in Col h, then return "on system' , otherwise "not on system" It would be appreciated if someone could assist me

Hi, I'm in the process of writing some VBA to match and extract data from one worksheet to another. Originally I was going down the path of VLOOKUP but have since read about Index & Match being the better way to go. I've attached a sample of the data here, any suggestions on the best way to...

Hi I opened a new workbook and wrote the code below in a module and tried to run it but got run time error telling me I need to change the extension? any help would be appreciated thank you. Sub wk_save() Application.DisplayAlerts = False Workbooks(1).SaveAs Filename:="hello.xlsm"...

I have the sample sheet below. I need to count how many y's and n's there are for each ad week per store. I tried a few different countifs with no luck. Any help is appreciated. <colgroup><col width="22" style="width: 17pt; mso-width-source: userset; mso-width-alt: 804;"> <col width="73"...

Hi All, I have a drop down with a specific month, my forula does the trick and displays all dates for that month, but how can I display WORKDAY's only? I am a bit stuck, your help is appreciated. A1 = Dropdown date: =IF(A1="","",DATEVALUE("1 "&A1)) The in next cell this formula...

Need to have the following formula round up anything over .0. Any help is appreciated. =IFERROR((D2*24)/9,"")

Hi, I have cells with data like below in a column. I wonder, can anyone help me with a macro to search and find any two consecutive cells with over 10 minutes difference and highlight them in yellow? Much appreciated. <colgroup><col></colgroup><tbody> 05/03/2019 06:34 05/03/2019 06:57...

Hi, I am trying to find out if it is possible to use wildcards in a formula. In the formula below you can see the items in the "OR" statement all start with "FAS-5". Any help is appreciated. Thanks =IF(OR($BF24="FAS-5 SL - HIGH",$BF24="FAS-5 SL WHITE",$BF24="FAS-5 SL ANOD",$BF24="FAS-5 DUAL...

Hi, I'm having issues with the below. I'm trying to trimmean the weeks where the weekly number is greater than 5. I want to trim the mean to then exclude the top /bottom 10%. Below is the formula I currently have which I cannot get to work. Any help is greatly appreciated. Thanks...

Hi, I’m very new to VBA and looking at its uses. One first thing I’m trying to go is create a VBA script in Excel to copy a data table from a webpage. More specifically, from https://uk.soccerway.com/national/england/premier-league/20182019/regular-season/r48730/ Does anybody know how to do...

I would like to set up CF for "No Shows" that appears in Col A I have set up a formula =ISNUMBER(SEARCH("No Shows",A2))=True The Rage is $A:$F It is highlighting all cells in green. It would be appreciated if someone can assist me

I have several sheets that have cells with no entry and sometimes they a null or blank or ")" etc. They mess with my formulas. So I though this would make them all the same, but it wont run. Any help is appreciated. What am I missing? FYI - it is formulated as a table - is that why it errors...

I am trying to sum the below based on how many months. I normally use a Sum INDEX but trying to build it into a SUMIF instead. My ideal result should be 9 but I keep getting 3. Is there a better way to do this? Any help would be greatly appreciated!

Hi All, I have the below formula but I want it to return it as a hyperlink as it looks up email addresses, can any one show me how to adapt. =IF($A3="","",IF(INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1)="","",INDEX(DB_List,VLOOKUP($A3,DB_RowIndices,2,FALSE),K$1))) Much appreciated...

Can someone help me 'tweak' this formula to only 'sum' if it sees a '3' in column AP? =SumCellsByColor(B27:AL27, $AV$4) Your help would be very much appreciated Marc

Hi I want to ask user to enter workbook number to close and then close that workbook accordingly. So I wrote the code below, but did not run. Any help would be appreciated. Thank you. Sub mywb2() Dim x As Integer x = InputBox("which workbook") "workbooks" &x.close End Sub

I am trying to copy a column from a pivot table and paste in a different workbook location. It appears to highlight the proper cells in the pivot table, but when it pastes, it pastes blanks! :mad: I'm at a loss of how to even debug the dang thing. Any help would be greatly appreciated...

Please help. I need to put a formula within a formula. I have to create a table on y values for the formula y=1/2at^2 +vt when t is seconds and v is ft/s and given that a=32ft/s^2. T, and v are both numbers but a I'd another formula and I dont know how to put it in my formula for my table. Any...

Hi, in the formula below when I insert a row the reference F6 changes to row 7. I would like to lock row 6 but have F change to G,H, etc. I see online a few ways to do it with indirect or maybe row function but I can't get it right. Any help would be appreciated. Thanks...

I am looking to roundup if the number in a cell ends higher than 0.2 and round down if its lower than 0.2 so for example 1.2 would round to 2 and 1.1 would round down to 1. Have tried everything with ROUNDUP and IF but can't work it out. Any help much appreciated :-)