appreciated

  1. W

    search function with or function

    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.
  2. T

    Conditional Formatting the alternate rows with Criteria

    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
  3. R

    Formula not working

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

    Conditional Formatting - need to add a "not equal to" to my formula

    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)))...
  5. D

    Deselect value in inputbox

    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
  6. S

    Time met and converting it to %

    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
  7. F

    This formula uses more levels of nesting than you can use in the current file format.

    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)...
  8. E

    Locking specific cells

    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...
  9. D

    Listbox to highlight current week when opened.

    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
  10. B

    Spaces spaces and more spaces

    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...
  11. gheyman

    CountIf Date is less than today

    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
  12. MUKESHY12390

    Dynamic use of Indirect Formula

    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!
  13. W

    VBA countdown timer

    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...
  14. K

    IFs, ANDs, and BUTs

    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!
  15. D

    Search 12345 and insert row above

    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.
  16. J

    ROUND UP FORMULA with IF Function

    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.
  17. B

    Easy VBA Loop Through Variables Looking for Boolean Flag

    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!
  18. H

    VBA - Hide Rows / Columns

    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
  19. J

    #FIELD! error

    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
  20. P

    Need help with Excel Launcher in excel 2003

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top