numerical

Hello all, This is my first post on this forum, so let me know I haven't described my problem well enough. I have an index match lookup function which returns the position of the last cell in a row containing a non-numerical value, to thus match the row number with the corresponding company in...

Hi, Can someone please help me with this doubt? I have the fallowing data and I would like to extract only the numerical characters: R111----> 111 AX12---->12 ADF1234--->1234 WRT999--->999 Thanks! Edu

Hi, I want formula in excel Value is 1 to 5 I want answer "A" if value more than 5 to 16 I want answer " B" if value more than 16 to 30 I want answer " c" if value more than 30 to 50 I want answer "D" if value more than 50 to 100 I want answer " E" if value more than 100 to 150 I want...

Good day all, I was making a spreadsheet and ran into an issue that I was not sure how to solve. I am using the =CONCATENATE function to write a text string for an email title as well as using =IF statements in it to determine some variable. I ran into the problem when I wanted to reference a...

In one of the columns that I'm copying from Excel to Access I have both numerical values as well as text values. When I copy it into an Access table, the numerical values are copied into the table but the text values are dropped. The field in Access is set to "Short Text." The field is empty...

Hi, I have a pivot table in hours. I would like to convert it in days. Does anyone knows how to divide the pivot table data by a numerical character? Thanks! Edu

Below is a screen shot of my RMD calulator that I use frequently at work. I would like to be able to key in a person's age in B3, and then have the corresponding RMD factor automatically populate in B4. For example, if I key in "74" into B3, I would like to have "23.8" automatically populate in...

Excel 2007. Cell A1 contains amount in numerical. Tax to be calculated on this amount. If A1<=250000 then no tax. If >250000 and <= 500000, then (A1-250000)*10%. Upto this I am comfortable with the formula, =IF(A1<=250000,0,IF(A1<=500000,(A1-250000)*10%)). There is a concession...

Can someone please explain why this formula doesn't work? "=SUM(D&A1&":D"&A2)" Where A1 and A2 equal numerical values that can be changed based on the users sum range desire. Thanks!

IV:9710388235LADD DISTRIBUTION LLC Did a search on extract, but couldnt find a solution, so I wanted to see if someone could help out. I want to populate 3 columns from 1 column. Column 1 would have IV: - simple enough as I can trim 3 characters. Column 2 would have 9710388235 - Anything...

Greetings, thank you for clicking on my thread! I am in need of your help. I am working on sorting a spreadsheet based on criteria in column C. Column C has a list of numbers, all of which are preceded by the letter A or B. Example: A72200100 B7810210 B72300100 A7810220 I want to write some...

I am doing a research project on the scriptures that involves me listing certain verses with their chapter numbers. My idea is to make one column where each verse and chapter I am referencing will be in this format ---> For example: chapter 5 verse 2 = 5.2. I formatted all cells in my column as...

Hello, I have a lot of sheet names with numbers and letters that currently go as follows: A10site1_1, A10site1_2, A10site2_1, A10site2_2, A11_site1_1, A11site1_2, A1site1_1, A1site1_2, A1site2_1, A1site2_2, etc (there's a lot more sheets but you get the gist) As one can see, excel is unable to...

Hi, Andrew recently gave me a hand with an Excel formula I had been working on to automatically construct an SCCM collection query from a list of computer names entered in column B of an Excel 2010 spreadsheet (found this thread here...

Hi I've got a list of people's tenure which I need to be in a number format in terms of years. The current format is: 0 years, 2 months, 24 days I want to express this in terms of years so it this particular example would be: 0.232276 Is there a formula that would allow me to convert...

hi all, I want to know how to have a numerical value of a cell but with the cell text being a word, how do i do it in excel '07? I want it so when i look at the cell i can see when the cell is(text) but when i multiply it by another cell the figure will be used?

Hello... I am trying to create a routine which finds all cells with a numerical value (no text or special characters) and replace those cells with an "X". I believe all the cells are formatted as "General". Any pointers on how to do this? Thank you,