numbers

  1. tlc53

    Formula - Return True if any duplicate numbers

    Hi, I've been struggling with this formula for a little while now. Basically, I want it to return True if any numbers are repeated in the range B8:DG22 however, I want it to ignore text or more precisely, the word "Blank". =SUMPRODUCT(COUNTIFS(B8:DG22,"<>Blank",B8:DG22,B8:DG22)-1)>0 Can...
  2. L

    numbers to text and text to numbers

    Hi I just watched a video of excelisfun, the link below and he suggested to change text to numbers by using -- in front of a function Right(). My question, why he did not suggest to go to Home-->Number--> then select number to convert to text to number. Another question. If I have the...
  3. A

    Number formatting into Sets of 3

    I have numbers in column A that look like this <tbody> 13,065,102 13,165 4,051,065 600 18,013,092 </tbody> But when I click in the formula bar they are really this (real numbers) <tbody> 13065102 13165 4051065 600 18013092 </tbody> What I need to do is to is put the...
  4. A

    Adding info from one sheet to another by matching vendor numbers

    I have two sheets of data. One is vendor payments, the other general vendor data from their master file. I need to add their federal tax id to the vendor payment sheet by matching the vendor numbers on each sheet. What’s the best way to do this?
  5. I

    VLOOKUP Returns #NA when data is present

    I cant wrap my head around this error, I have 2 excel sheets, I am using VLOOKUP to add new pricing from the new sheet to the old sheet, I have triple checked a couple of numbers and noticed some exists on both sheets. Yet I it inputs #NA in that cell, I have cross checked a few numbers and saw...
  6. W

    Value returns null and error from text to numbers in query

    Hello I have imported a text file to excel using power query. I want to convert a columns value from text to numbers but when i do so it returns "null" and "error" values throughout the column. I am using excel 2016. Gratefull for any help i can get :)
  7. M

    Return value if there is an #N/A error

    Okay so I have a list of numbers that will be pasted next to an already placed VLOOKUP function, this VLOOKUP will lookup the numbers pasted in another list. This means the VLOOKUP returns a list of all the numbers that already exist in the 'lookup list' and then #N/A if a new number is there. I...
  8. nikio8

    Alternative to solver, numbers (no more than 5) add up to goal, several hundred rows

    Hi team, I have a bit strange problem. Quite often one payment needs to be split to several invoices. Most days there are no issues, however some days this split data total does not add up to original number. If there is a difference I would like to use some formula to try to find combination...
  9. willow1985

    Formula to determine next sequence of number starting with 3 letters and in random order

    Hello, I have a list of form numbers that are in random order (see below example). Is there an excel formula that could check the entire column, only look at numbers starting with IAF and determine what the next form number would be? IAF 1234 IAF 1201 IAF 1300 IAF 1001 So it would return: IAF...
  10. G

    Sum Formula with Criteria/Match

    Hello, Looking for help with a formula. I've got a spreadsheet that is just names and some numbers next to them. The names show up multiple times so I need the formula to look at each name, pull the number next to it, and sum all the numbers today. In the example below -- formula should see...
  11. C

    Macro/VBA to present user a look up box, and then add rows depending number of rows needed.

    Hi - first time caller, long time listener. In my world, I have a long list of parts. What I want to do, is create a macro, that will when run, ask me what part # are you looking for. When found, it looks up the part and inserts the necessary # of rows. What I have is service kits that are...
  12. L

    Parameter changing once function run

    Hey guys, i am making a small function to add up all the numbers between 2 numbers. My code: Sub Sums() Dim a As Long, b As Long, i As Long, n As Long, ta As Long, tb As Long, ak As Long, bk As Long a = 0 b = -2 ak = 1 bk = 1 If a - b = 0 Or a + b = 0 Then n = 0...
  13. R

    IF formula comparing to numbers, and allowing for rounding

    I have three cells. A20: 38.2 B20: 39.3 C20: contains IF formula to tell me if A1=B1, then "Good", if not, then "Check" To clarify, columns A & B contain numbers with decimals, row 20 would be the sum of all those numbers for each respective column. However, due to decimals, the totals won't...
  14. C

    Addig specif numbers within one cell

    I have an attorney billing template in which I enter data as follows in one cell: Office conference with Blank Client regarding freight damage [1.25]; review documents provided by Blank [1.5]; memo to file re potential case [.5]. I would like a formula or way to have all the numbers inside...
  15. W

    Very large numbers automatically rounded down to nearest thousand?

    Good morning, I'm working in MS Excel for Office 365 (MSO 16.0.10730.20344) 64-bit. I'm copying large numbers over from a table to a new sheet. They're all numbers stored as text. I can convert them into numbers. They're all different numbers stored as text, but when I convert them back to...
  16. C

    Decimal signs "," & "." - causing issues

    Hi, I have a template that calculates costs for services per month based on input from managers. I have set dot/"." as default decimal sign whilst everyone else have comma/"," (applies to all excel files you open). Due to this, they can not see the calculated costs for rows that contain cells...
  17. B

    Simple Fx using addition leads to #VALUE result and I don't know why...

    (Excel for Mac 2013) I'm sure there is a simple solution: I am adding up every other cell in a horizontal row (A1+C1+E1+G1+I1) and totaling the numbers in these cells in cell K1. In cell C1, there is an =IF(AND fx that results an integer, but when I add cells A1+C1+E1+G1+I1, the fx result in...
  18. J

    Filtering a Pivot by user input value?

    Hi, I have a pivot table with the left column numbers 1-100 And I want to be able to filter between 2 numbers (from user inputboxs for min and max) Eg. Numbers 11-20 or 1-80 Unsure how to do this, Any help appreciated
  19. A

    formula to find sum or 2 numbers that could be plus or minus

    I need to find the sum of 2 numbers and those numbers could either be plus or minus. How would a formula be written for that? Not sure if I'm asking the question well, so I'm after this: Example: A1 = .0695 A2 = -.0010 Answer = .0685 A1= -.0695 A2 = -.0010 Answer = -.0750 So, A1 and A2 can...
  20. M

    Look up Formula

    I am trying to create a formula: I want the formula to do as follow if cell A2 = any number for example 100 then cell B2 will equal 1 <tbody> 100 1 110 6 115 9 </tbody> the purpose of this is to match the database with license numbers and ranking based on those license numbers...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top