numbers

Hi, Is there a way to extract the numbers from the cell. For example: A1 <<<<< Manikandan S Natesan (17.09.2019-12:48:31) >>>>> 9161995548 9161995551 9161995552 9161995553 <<<<< Shanmugapriyan Malliraja B1 I need the numbers starting with 91, which is 9161995548 9161995551 9161995552...

I am having a brain block. I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order. I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column...

Hi I have the data below and I want to hide only positive numbers. So I went to Format Cells --> custom and typed ; I thought that would ignored the +ve only since I did not write anything for the positive. I know custom format is like this positive; negative; 0; text so ignoring positive...

Hi, I managed to have certain cells of my sheet1 reference others from sheet2 If a condition was met by using sumproduct. I managed to get this reference by using offset as I wanted to automate it by having it index numbers every 4 columns. it went smoothly while I was using no column offset...

Hi all, I'm having issues with a file I'm working with. to make it brief. I'm trying to get data from a second sheet (1) into my main sheet (2). the second sheet has data of budget spent every month for a range of work numbers, the total spent (which is the figure I want) is every 4th column...

Hello, I'm looking to use this formula =SUMPRODUCT(LEFT(G3:G100,2)+(RIGHT(G3:G100,8))) with cells that have numbers in but some in the middle are blank. If I try and return it at the moment, I get a value error due to blank cells. How do I get it to skip blanks? I don't want to shorten the...

Hi, I'm hoping this will be a pretty simple one for all you experts out there. I have a range of 5 numbers and I just need a formula to give me a yes/no or true/false for if any of the numbers appear in a different range of 5 numbers. For example: Range 1 is 1,2,3,4,5 Range 2 is 7,8,9,10,1...

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

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

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

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?

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

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 :)

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

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

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

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

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

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

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