formula & text

  1. S

    COUNTIF in array formula isn't allowed, while COUNT is. Why ?

    Can you please help me find a way around Can't figure out why this one working: {=COUNT(ISNUMBER(SEARCH(List,E522))*(ROW(List)-1))} Which evaluates in something like COUNT({2,4,6,2}). And it results in 4 Now I want to count only 2. So I use...
  2. S

    If #REF then load to Query If #VALUE then don't. Need help with loading #REF records

    Hello, Can you please help me find a workaround to load needed records Is there a way to replace #REF error, but keep #VALUE one ? Or in other way, Is there a way to load #REF records , but exclude #VALUE ones ? If it helps I use the following formula in order to find keywords. And result...
  3. S

    Sumproduct formulas to exclude specific text/values in count and totals

    Hi, Can't attach the the file to the post as there is no option to do so which I need help with but this is where the file is located: https://trumpexcel.com/excel-leave-tracker/ What I want to change in this file is to include “IN” and “OFF” on the calendar days that employees are working and...
  4. Atif

    Excel Sort Question

    Is it possible to Sort excel in multiple columns when there is a formula in each column's cell? I was trying to Sort using Data >Sort and noticed that when I chose column Sort by - Column C it doesn't change other cells (ex. A, B, D & E) accordingly. Please note - Cell A contains Name like...
  5. S

    Extracting variable length data from cell

    Would like a formula which would extract the contents between the word circuit and the second comma in a string: MPLS - MPLS Services, Circuit 2083676, Verizon, xxxx,,xxxxxxxxxxxxx , xx MPLS - MPLS Services, Circuit 572222DAT1, xxxx,xxxxx,xxxxx
  6. T

    Copy cell to new tab from another tab but skip empty cells

    Hi, Please HELP! I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell. TAB 1 (ColumnA) (ColumnB) <tbody> Name Amount Anne OFF Amy Mike Doe OFF Anne...
  7. A

    Extracting multiple numbers from one string with blanks & text in it & put into separate columns

    Hi This is the problem. I have a column with something like the following: Column B Line 1 SS 2 d' FS 0 d Line 2 SS 5 d' FF 6 d Line 3 FS 0 d Line 4 FF 0 d' SS 3 d' FS 0 d' FS 0 d' SS 3 d' FF 11 d' And so on each line can be and is different. What I need is all the...
  8. S

    Formula to Match Text and update for same values in the row

    Hello Team, Need to look for "AA" in the Text and if so update the Yes in result , for those multiple invoices if the Text is also not equal to "AA". i have trying with below formula, but stuck: =IF(AD16="AA","Yes",IF(MATCH(J16,$J$16:$J$22,0),"Yes","No"))...
  9. G

    Automate charts with data formulas

    Hello Excel friends, I'd greatly appreciate help to learn how to do a couple of Excel tricks. The 'Data' sheet contains a single column A which houses the data in <Sheet1!B:B>. I'd like the chart to always display the x-most recent quarters of data, x being $C$2. If it's possible, I'd like $C$1...
  10. S

    Struggling with drop down and IF (maybe) formula with text

    I have gave this a good bash and got close but struggling as it is text. So here is the problem. Col A and C are working great. Col. A = dropdown options (15ft basket, 10ft basket, 30ft pipe) Col B = 15x8x4, 10x4x2, 30x1x1 (Dependent on col A selection). Col C seems to be working fine with...
  11. C

    How do I multiply 2 cells if a 3rd contains certain text

    Hi I'm trying to find a formula that where row# in Col C =1 AND same row Col A=Q1 I sum the cells in Col B from those rows <tbody> Col A Col B Col C Row A Q1 5 1 Row B Q1 2 Row C Q2 1 1 Row D Q1 6 1 Row E Q4 3 </tbody> In my spreadsheet I have to repeat...
  12. J

    Formula to Search multiple criteria of month/year within a cell and return total numbers from a different cell

    Hi All, I've tried countif using substitute, but I know I'm missing something. I can't figure out how to incorporate counting column B (numbers) if SOME of the text from column A matches column C, provide the total numbers of column B. Ultimately, I would need 8 different text to find. I'm...
  13. I

    Insert Charters into a number string vba or formula?

    I'd like to update a string of numbers and add charters before each string of numbers. IE <tbody> 006-01-00-00 R006-B01-S00-P00 006-01-01-00 R006-B01-S01-P00 </tbody> :confused:
  14. mikecox39

    formula replaces text

    I have a lists worksheet with an account listing in A13. In my Master worksheet I have an account column with that account name in cell A18. In the details page that account doesn't display in the accounts column I entered =Lists!A13 in cell A18 on my Master worksheet, the account name went...
  15. D

    Read text in one cell and fill another

    Hi, So I am trying to create a Fantasy Football spread sheet. I want to create a formula that will read the team name in the cell next to it and then spit out the bye week that team has assigned. For example if E4="ARI" then I want F4=8 for their bye week being week 8. While it is easy to...
  16. H

    Formula to separate number from given line of text data

    Hi All, I hope anyone can help me with below request... I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number. Example Data...
  17. E

    Extracting Text from a Cell based on the furthest symbol to the right below it?

    I've been having a hard time finding a solution for this problem I'm having. On Column A is a name of an edit to a certain set of drawings. The drawings are on Row 3, starting at Column E (ie: E4) and the symbols found on row 4 signify which of the drawing sets have the latest revision...
  18. C

    999 Emergency!! Staring into the abyss of spreadsheet-induced insanity please help!! How to automate changing formula in col C that uses data in col B

    Hello! I just signed up and this place looks like heaven to me right now after hours of sweating and crying over this spreadsheet. I have data for thousands of people. The people all have a name, listed in column A. Then in column B is the date at which they logged their weight on an app. In...
  19. T

    Formula Troubles

    Hi, I am having troubles combining different cells into 1. Here is what I have so far. <tbody> Lesson Study Learning Study Action Research Video-based Research Learning Circle Combined 1 1 1 1 1 1 1 1 1 1 1 </tbody> So far I have used index match and vlookup for combined...
  20. D

    Removing zeroes in number format

    Our customer numbers begin with A followed by four zeroes and a string of numbers. Example: A00002121256438 A00002178164211 A00002191112936 A00002152291978 How can I create a formula to remove the 4 zeroes following the letter A so that the...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top