1. S


    Hello, So the cell contains "MattressSofaCouch-1", I currently have the isnumber function to identify whether it is a mattress, sofa or couch but I need an adjustment to the formula to designate the "-1" as the color black. Right now when I use the ISNUMBER formula and add the "-1", it pulls...
  2. F

    Any of these in any of these

    I am attempting to get a count of all the cells in K:K, that contain the same value as any of c12:c43 from a different tab. I got it to work by using a long string of countifs, but that seems like way to much work for excel. I have tried using SUMPRODUCT, SEARCH, ISNUMBER, COUNTIFS,ETC. This...
  3. M

    IS NUMBER SEARCH with TWO conditions

    Hi I've got a formula which searches for specific text in a cell, then returns a phrase if that text is in the cell. In the example below, if the word "Now" appears in the text in cell A1, then the phrase "Fixed Price Discount" will appear in cell B1. The formula I have used is...
  4. T

    Return Highest value if Range of cells dont contain "Sat" or "Sun"

    <colgroup><col><col></colgroup><tbody> Occupancy Occupancy Start Occupancy End Occupancy Start Weekend Occupancy End Weekend DHW DHW DHW Start Monday 05:00 DHW Start Tues - Fri 05:30 DHW Stop Mon - Thurs 15:00 DHW Stop Fri 15:00 DHW Start Sat 09:00 DHW Stop Sat...
  5. I

    ISNUMER and MATCH: on two columns

    is it possible to use ISNUMBER and MATCH on two adjacent columns. I want to use ISNUMBER and MATCH to return true i the formula finds A,B,C,D,,F,G,H,I, or J in either of the ranges. Range A1:A5 house A,B,C,D,and E Range B1:B5 houses F,G,H,I,and J
  6. S

    ISnumber with Index/Match GoogleSheets

    Can someone please help me, what is wrong here? if(ISNUMBER(A68),INDEX('Pricing & Availability'!A:E,match(A68*1,'Pricing & Availability'!A:A,0),2),INDEX('Pricing & Availability'!A:E,match(A68,'Pricing & Availability'!A:A,0),2)) I am getting the massage: "Error Did not find value '9178891612'...
  7. D

    Can I use Isnumber(search()) to extract from a string, from lookup table?

    Hello, I am trying to extract part numbers from a columnfull of strings. The part numbers are in different places in each row. I have alist of part numbers so I can wondering if I can use Isnumber(search(Lookup or indexmatch function)) to extract the part #sfor each row. I can’t put the part...
  8. G


    I am trying to figure out how to get the right formula to output the column header i need. I tried isnumber with index match and i'm getting n/a or value errors. <tbody> US1 US2 US3 US4 US5 US6 US7 US8 US9 US10 123 456 SERV678 542 369 87 654879 14 </tbody> I need to find the cell the has...
  9. D

    If Statement + Is Number + CountA

    Hello- I have the following data set, which I'm trying to calculate the time spent based on =CountA of the items (columns A-E below). <tbody> Col. A B C D E F G H I Item 1 Item 2 Item 3 Item 4 Item 5 Total Time Spent (mins.) Time Spent - Item 1 Time Spent - Item 2 Time Spent - Item 3...
  10. N

    SEARCH for multiple words

    I'm trying to search cells for certain letter combinations and seem to have forgotten how. I want to look at cell H3 on another sheet for code "WJ" and/or "SP" and come back with TRUE for true and blank for false. The only time it should be false is if neither WJ or SP are in the cell. The...
  11. L

    match two separate arrays with three individual cells

    This is an odd case I know, but given a ton of data in this sheet, I need to perform the goal without having to rearrange the data or use VB/macro. The areas of concern are in bold red... Trying to match E3:F7 with I7:R7 (in this case should = 0,1,3,4), and then see if those matches...
  12. D

    Sum Cells In a Range IF 3 'Contains' Criteria are Met

    Hi all, hoping you can help me. I want to sum cells within a range, only if 3 criteria are met, but each criteria is specific to finding specific text within other cells in the same row. For example: <tbody> Set 1 Set 2 Count Good fruit This apple is red 5 Bad fruit This apple is green 6...
  13. M

    Help needed debugging SUMPRODUCT

    Hi, I'm in the process of replacing SUMIFS with SUMPRODUCTS for closed workbooks and have hit an error I cannot solve. The offending formula is: =SUMPRODUCT(--([MFT.XLSX]Perth!$5:$5=TEXT($U$1,"mmmm")),--([MFT.XLSX]Perth!$6:$6=$W$1),[MFT.XLSX]Perth!$21:$21) It is returning DIV/0 I know...
  14. G

    Array search by criteria to return found criteria

    I feel like I'm halfway to what I'm needing. Here's what I'm starting with: <tbody> A B C D E F 1 Description word list 2 The zookeeper was reading a book about a dog, bear and fish. TRUE aardvark 3 The girl has a cat. TRUE bear 4 The...
  15. M

    ISNUMBER is not working properly

    I have column B with either a numerical value or a letter text. In column M, I need to use only the numerical value and regard the text as 0. In M, I entered =IF(ISNUMBER(B5),B5,0) But, when B5=7, it returns a 0. When B5 is a T, it returns a 0 as well. Column B is formatted as a Number (0...
  16. C

    Know if the last char is a number

    Hello ! I need to know, in each cell in a range, if the last char of a cell is a number (the cell can contain text but i want to know only if the last char is a number), and if not, I want to show in a message box and highlight it. I have written this code by adapting another code I have, and...
  17. J

    MIN and ISNUMBER functions

    I really am not big in excel but know some of the basics. Trying to calculate the percentage completed of a target set. Due to other formulas in the spreadsheet, I have had to use the ISNUMBER function so that it only returns a result if there is data to pull (instead of giving me a #DIV/0...
  18. I

    Array Index/Match + ISNUMBER/Search not returning result?

    1) I am having trouble entering the formula as an array. I press control + Shift + enter, and nothing happens (using office professional plus 2013) 2) Not sure if the formula is correct, I'd like to pull the number into the adjacent (C) column. Excel WorkbookBC2TitleVGA Grade3NEW PlayStation 3...
  19. K

    Multiple IF ISNUMBER SEARCH for multiple criteria and each column

    Hi, this is my first post here. I have a sheet to calculate the working time. The thing I want is that if Mr A is present in J9 & X9="Whole day" then his total working time is 7:00 and the result will be in V9. On the 23rd if Y9="Morning" then his working time in V9 will be 10:30 and the same...
  20. V

    Formula gives value in range expected, but...

    but, when entered in to a cell the value does not appear, but instead there is a zero. Isnumber confirms it configured as such. Can you help?

Some videos you may like

This Week's Hot Topics