1. T

    Counting unique values with FREQUENCY, ISNUMBER, SEARCH, and MATCH - problem when adding date

    With below formula I am counting unique values. Everything worked well until I added the dates. Any suggestions to solve this? Picture attached =SUM(--(FREQUENCY(IF((N:N="Installer/Contractor")*(ISNUMBER(SEARCH("|"&I:I&"|";"|Visit|Online Meeting|Webinar|Join Visit|")))*(ISNUMBER(SEARCH("Ole...
  2. T

    ISNUMBER - Return specified values?

    Is it possible for ISNUMBER to return values other than True/False? For example, if the cell I'm targeting contains literally any numeric value and not a word value, can I make it return "Number" instead of "True" For whatever reason I could find literally nothing on this subject outside of...
  3. P

    Use ISTEXT or ISNUMBER with Right Function

    When I use the ISNUMBER or ISTEXT function for the whole cell, it gives me the correct true or false result. When I use the ISNUMBER OR ISTEXT with the right function to extract the last 3 characters it is giving me the incorrect results. I want Excel to see the the last 3 characters as if it is...
  4. M

    Need Help with Match/IF/ISNUMBER problem.

    I have a problem I'm trying to solve. hopefully I explain this right. I'm trying do find a formula to insert 3 missing columns of data from another data set that has those columns. the data with the missing columns has over 600 rows. and duplicate values.. the data that has the columns i need...
  5. P

    INDEX MATCH -> multiple results from 2 columns

    Hello, I'm trying to get 2 multiple results from 2 different columns under 1 column and in order. Column E = Matching Apple in column A -> returning C value {=INDEX($C$1:$C$6,SMALL(IF(ISNUMBER(MATCH($A$1:$A$6,$E$1,0)),MATCH(ROW($A$1:$A$6),ROW($A$1:$A$6)),""),ROWS($A$1:A1)))} Column F =...
  6. M

    True statement with ISNUMBER

    Hello, I have the following formula written, but it’s not returning both ‘true’ or ‘false.’ Would love for feedback: AND(Q2=“abc”,G2=“D”,ISNUMBER(Match(k2,abc_dom,0))) Essentially, want to say if cell Q2=abc, and g2=d (that’s true) and if cell K2 matches the list from abc_dom, return false...
  7. H

    Adding a wildcard function to an excel array formula to return multiple values vertically of both Number and Text

    Hi all, First I want to apologize if my question lacks some formula knowledge, I'm new to this level of Excel and trying to figure this out. Second, I want to thank all for tolerating my ignorance. Here is my challange: I'm designing a stopgap solution for querying a large Excel spreadsheet...
  8. D

    IF function with ISNumber(Search()) and Vlookup

    Hi! I am trying to write a function that would use two vlookups, where in the first vlookup there are also IsNumber(Search()) supporting it. What I have written looks like this - IF(ISNUMBER(SEARCH("part of text", d3)),VLOOKUP(D3, 'tab x'!A:B,2,false),VLOOKUP(D3, 'tab x'!A:C,3,FALSE)). As you...
  9. M

    Count Number of digits 0-9 to the left of a Specific Character in a Cell

    I used a formula to parse a field that typically contains text like the following: 1F5H or 13F1H The following formula works just fine when the number of digits to the left of a given character is static, like 1 numerical digit. However, I'm not sure how to determine how many numerical digits...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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
  15. 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'...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back