appreciated

If I add a new column A, that changes all of my other formulas. Is there a way to add a new column (every 2 days) and have it add the new column in the formula? Example. I have in M2 a formula: =COUNTIF(A$2:C$30,L2) But, when I add a new column A, the new formula will be =COUNTIF(B$2:D$30,M2)...

how do you incorporate the search & or function into the same formula? i keep getting #Value with my formula. Any help is appreciated. =if(search(or("Best","Good","Average"),A1,1)=1,"Pass","Fail") Thanks.

Hi there! I have shared the screen shot in the link below:- In the rows "Dinner" (not the rows "Breakfast"), if there is any letter other than "D". The cell/cells should be highlighted. Any help would be highly appreciated. https://www.dropbox.com/s/4ys79pbmixi1o3b/Question.png?dl=0

I can't seem to get this to work =IF(ISNUMBER(SEARCH("Rejected",A2)) =IF(isblank,"","Today")) Any help would be appreciated. Dorinda

Maybe it's because it's soo late and I'm here working on this but I can't figure this out. Help from the masters would be appreciated. I have a conditional formatting formula already setup and it works... <date(2019,8,2))) AND(($AZ10>0.249),($F10<date(2019,8,2))) <DATE(2019,8,2)))...

Hi, Is there a way of deselecting the value that is in my input box when it opens? If so I'd like the prompt to be after the value. Any help would be appreciated. Thanks Dan

Hi There! Help is definitely appreciated on this one! I have a spreadsheet that has a “loaded trailer time“ and a “cut off time“ of when the trailers should be done. I have to show on a daily how many trailers met that time cut off and represent it as a %. Please please help

Hi, Im trying to run this query and getting the above alert. Any help is appreciated :-) =SUMPRODUCT(MID(0&E66, LARGE(INDEX(ISNUMBER(--MID(E66, ROW(INDIRECT("1:"&LEN(E66))), 1)) * ROW(INDIRECT("1:"&LEN(E66))), 0), ROW(INDIRECT("1:"&LEN(E66))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(E66)))/10)...

Hi all, I need some help fixing this code. Worksheets("Sheet1").Range("A6:A167").Locked = FalseWorksheets("Sheet1").Range("C6:C167").Locked = False ActiveSheet.Protect Password:="abc" I am trying to lock those specific ranges, but it keeps throwing an error every time I try to implement it...

Hi, I have a listbox (listbox1) with the numbers 1-52 in it. I would like a code that highlights the current week when the userform is loaded. Any help would be much appreciated. Thanks Dan

Hello all, I have a text file that gets imported into excel that is + separated. Most of the columns have many spaces at the end of them. I can't use the space separator during the import because it will break up areas of descriptions. I would love to hear your thoughts on how I can get rid of...

I have dates going down column M starting in row 5. I want to count how many are less than today Any help is appreciated. Thank You

Hi All - Is there any way if I can make "D2" dynamic. I mean while pasting it to other Row or other Column "D2" should change to D3 or E2 ( Bascially I want to adjust Relative Reference concept while pasting.) =INDIRECT("Sheet1!"&"$D2"). Any help would be appreciated. Thanks!

Hello, I want to make a countdown timer with counting to a date in the future in format "dd hh:mm:ss" or similar. F.e. how many days, hours, minutes and seconds left till "21/10/2019 15:00:00". I have newly found the timer function, but can not make it count backwards. All help and ideas...

Need help finding a formula for the following conditions: If AV14="Yes" AND AV76 is a number, then enter the value of AV76, BUT if AV14="No" then enter "N/A". Any help would be appreciated. Thank you!

Hello I'm looking for a macro that will search the whole sheet for 12345 and if found then insert a row above and position the cursor in the Cell A of that inserted row, any help would be appreciated. Thanks.

I need help with roundup in an if statement. =ROUNDUP(MONTH($G7)/3,0) I've tried everything that I can think of with no luck. Any help would be appreciated. I need Quarter come from Date but if there is not date formula show 0 not value.

Hi All, I'm attempting to write a code that looks through a potential of 50 different Boolean variables and creates a new variable "YES" if at least one is flagged yes. I am extremely new to VBA and just know basic loops. Any help would be appreciated. Thank!

Hi, Using below code to hide rows based on column A if the value does not equal 1 Sub hide() Range("A1", Range("A" & Rows.Count).End(xlUp)).AutoFilter 1, "1", , , 0 End Sub Is there a way I can use this code to hide some columns ? Any help would be appreciated Regards, Humayun

Hi If I type "=-85.00" into a field in excel I get #FIELD ! If I type this on my other computer I get -85 I presume there is a setting I am missing Any help would be appreciated. John