By "Return all row numbers that have a given value written somewhere inside text in their column B" I mean....

I want to be able to search an alphanumeric value "ABC12345" within a column that has a paragraph of text written in each row, I want to know which rows have this value written somewhere in them and have it return 2,4,33, as row 2 and 4 and 33 have this value in them inside column B on that row.

on column A i have the respective row numbers all the way down ie: ( 1,2,3,4, etc) (to pull up the row numbers)(unless you have a better way)

On Column B i have the paragraphs of text to search in (there is lots of text and spaces in the paragraphs.)

On column C i have the value to look for... ie: ABC12345 (different values in each row of column C) to be compared to all of column B

On column D would be the formula to Pull down and get the results.

and something tells me you might have a better way of getting the row numbers rather than having column A dedicated to numerating each row 1,2,3,etc

1 paragraphs of text look for it's found in row #

2 anything can be written here and might have ABC11112 DDD77777 4

3 anything can be written here and might have ABC12345 ABC55555 5,6

4 anything can be written here and might have DDD77777 BBB11111 Not Found

5 anything can be written here and might haveABC55555 ABC11112 2

6 anything can be written here and might haveABC55555 ABC12345 3

I am working in Excel 2010 (Windows 8) and am having real problems trying to find a function/formula that will work with both numbers and text. I am trying to identify if the contents of Col A cells and Col C cells on each row are duplicated within a worksheet, and if they are, to add a 'J'.

(Column A is a list of numerical company codes and Column C is a list of adviser codes using the letter A-G. If a company ID code has more than one of the same adviser codes referenced to it, it is termed 'Joint', hence the 'J').

The formula I've used is: =IF(A2:C2, FREQUENCY>1, "J")

Is there a way to pull out numbers from a cell that has letters mixed in with it. I tryed using Right() and Left() with the LEN() function but sometimes I might have (examples: "TP3470" or "9310-AV") and all I want to get is ("3470" and "9310") I also may have (4500SSML). I cannot find anything anywhere on pulling out just numbers or text. Maybe a custom format?

I need to remove numbers from a string of text and put them into new cells in Excel Starter 2010. There are two different values which need moving. The first is in parentheses and the second follows the parentheses.

Here's a few examples of what I mean:

Original text RED008 - Wickaman and Hoodlum bandwidth (0.06Gb @ 2.00) 0.12 MFR005EP - Various Artists bandwidth (0.19Gb @ 2.00) 0.38 RAZORS010 Future Cut bandwidth (0.01Gb @ 2.00) 0.01

would like to split into...

Cell 1 RED008 - Wickaman and Hoodlum bandwidth MFR005EP - Various Artists bandwidth RAZORS010 Future Cut bandwidth

Excel 2010, I have the following list (showing part of it):

Name T-Shirt Sizes Nathan S

[Code]....

The aim of the list is to see what Sizes each and every person needs and then count how many T-Shirts are required for that particular size. The list is over a 100 entries long so counting it manually isn't really an option as it's time consuming as well as errors might arise.

Thus, I've been trying to use the IF statement with the following logic but to as no avail

IF Size in Column is XS Add 1 to a particular Cell IF Size in Colum is S Add 1 to a particular Different Cell

and so on for the other sizes...kind of like a counter for a for-do-loop.

I have a text file with rows and columns of numbers ranging from 1-4 digits that I'd like to import/copy into Excel with each number being in its own cell. But whenever I copy/try to import, Excel splits all of the 3-4 digit numbers up into single digit numbers. The text file has 10,000+ columns (each number occupies two columns so I have half of that amount in numbers) and 300+ lines.

Is the file simply too large for Excel to handle or is there a way I can do this?

I want to ask that I have got a workbook with different number series i want user form where i can enter its start number and end number and then it finds and delete shift cells up said series number i have entered in user form please see mentioned below example.

Series 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 and i want to delete 1 to 5 numbers delete to shift cells up.

Whilst I was searching through the channels on telly the other night I came across a 'Quiz Call' channel where you had to add ALL the number within a certain sum (see sample) Sixteen minus five times seven multiply by nine add twelve

You not only have to do the sum you also have to add in all the less obvious numbers like the Six within Sixteen, plus also all the Roman numbers in each word like the I, X, & IX within the sixteen. I've done a small example to show what I mean, but I don't have any idea how to create a formula that will add up all of all of the permitations of roman numerals within each word.

I'm designing a spreadsheet for our department which tracks a students progress throughout their time at the school. There are 4 levelsStatementSchool Action PlusSchool ActionMonitorIn year 7, they may come into our school at Monitor level, but when they get to year 8 they may have moved to Action Plus. I want to highlight that change on my spreadsheet with conditional formatting if possible so if they go up, the cell will turn red, if they move down the list the cell will turn green.

I've created two columns on an options sheet (which holds all my data validation lists) and assigned a number to each of the levels so i can conditionally format my columns using < and > but I don't know how to write the lookup formula

I'm currently working on my masters dissertation and am using excel 2010.

Basically, I'm trying to generate a list of say, 1000 numbers within a range. I can already do this using the rand() function. However, I need excel to take each random number, apply it into a formula, and then list the answers in a seperate location. This would be easy to do if there was one simple function (which i could just insert into any adjacent cell). The problem is that each random number value is input into a table. The table, which has about 10 columns and 200+ rows, gives one final answer.

I'm sure there has to be a faster way than creating 1000 tables for each random number generated.

Let's say I have a list of 1000 random numbers in sheet 1. the function table is in sheet 2 and produces the answer in the same sheet, in a single cell. I'd like excel to use each random number generated, input it into the function table, attain the answer from the table, and list it in the cell next to the random number.

I have given a table with some decimal values like e.g 0.3658 0.358 0.485 0.7863 0.558 0.858 0.985, I want to find the sum and average of these number.

1) I have tried the autosum or auto Function =AVERAGE(A2:A7) but it yields #DIV/0! error 2) when I use =AVERAGEA(A2:A7), it yield ans=0 3) puttin =ROUND(AVERAGEA(H2:H23);3) also yields 0;

Open a brand new spreadsheet whether the format is set to "General" or "Text" it will not let me enter numbers. For example, when I enter 2007 in the cell it displays 20 07 not really that big of space between the two zeros - but still a space. I can't format this no matter what I do.

In Excel 2010, I have a list of numbers with about 7000 rows. I am trying to track the number of times the number "22" appears within 30-day periods, with the end-result being a "count column".

While I could enter a formula manually for the date ranges, there are over 200 time-spans I'd have to enter (list goes back to year 1994). Is there a way to automate this process...

Excel 2010ABCDE1DateNumbers List# of Days AgoCount for number 22205/31/12304305/30/12602405/29/12909505/28/12301202605/27/12391505705/26/12371807805/25/1222210 11905/24/123824051005/23/122227091105/22/123230011205/21/123533001305/20/12383608

I'm currently working on my masters dissertation and am using excel 2010.

Basically, I'm trying to generate a list of say, 1000 numbers within a range. I can already do this using the rand() function. However, I need excel to take each random number, apply it into a formula, and then list the answers in a seperate location. This would be easy to do if there was one simple function (which i could just insert into any adjacent cell). The problem is that each random number value is input into a table. The table, which has about 10 columns and 200+ rows, gives one final answer.

I'm sure there has to be a faster way than creating 1000 tables for each random number generated.

Let's say I have a list of 1000 random numbers in sheet 1. the function table is in sheet 2 and produces the answer in the same sheet, in a single cell. I'd like excel to use each random number generated, input it into the function table, attain the answer from the table, and list it in the cell next to the random number.

I have a column of Dates in Col B with corresponding X values in Col C. I specify a start date in Cell F14 and an end date in Cell F16. I then use the function shown in cell H6 to identify the starting row number (corresponding to start date) in Cell F6. If I used the same function to identify the end row (in this case 4/2/13), it would choose row 8 which is the first row in which it encounters that date. Unfortunately, I need the end row to identify the last row that date appears in. In this case, that would be row 11.

Excel 2010ABCDEFGHIJKLM1 Date and TimeX2 3/30/201334/1/2013 1:366.9744/1/2013 4:563.95 54/1/2013 4:573.27 Start Row64/1/2013 5:165.553=MATCH(DATE(YEAR(F14),MONTH(F14),DAY(F14)),$B:$B)+174/1/2013 5:172.35 End Row84/2/2013 17:191.59894/2/2013 17:192.81 104/2/2013 17:252.14 114/2/2013 17:262.05 124/3/2013 5:152.84 134/3/2013 5:154.11 Start Row144/3/2013 5:173.2404/01/13154/3/2013 5:173.45 End Row164/3/2013 17:124.0304/02/13174/3/2013 17:133.621819Sheet1

I am trying to find duplicate numbers in sets but so far I can only highlight the ones that are in exact order. I need to find each set that has the same numbers, in any order. Example..

I will provide an example of sets of 3. But I get 3, 4 usually but sometimes 5 or 6.

I get them from different people.

Person A- 234, 569, 498, 849, 848,343,567,347 etc...

Person B- 432, 596, 677, 566, 565,433, 455 etc..

Now I need to find each set that has the same numbers, any order. Like 234 from A and 432 from B would be the same, so I would need to highlight them 2 sets. But I can not figure out how to do this. For Excel to highlight it they have to be 234 and 234. Does not recognize same numbers, different order.

I am using Excel 2010 and I am trying to calculate 4 different factors' (columns) values which are numbers. Based on my analysis I will assign the value from 1-5 for each factor and at the end I have to decide the priority (a new column) adding all 4 columns' numbers. My Priority column has three criteria (High, Medium, and Low) but I don't know what formula/function to use and how. I have tried IF function but did not work.

I have a spreadsheet with numerous transactions that contain the same name but are often spelled differently or inconsistently. I would like to pull all the transactions with the similar name and in a new sheet, make all the inconsistent ones, the same e.g. (space)mr smith or mr smiths or mr smith's or mr smith would all be mr smith. I am thinking of using the match command as a possibility but want it to repeat each row.

I am attaching a spreadsheet to show the existing table and the desired result which is similar to what I am showing below.

Example:

Existing Names and data A B C D E 1mr smiths xyz10020% 2 mr smith abc12430% 3mr smith's def20040% 4mr smith xyz7550% 5simon inc zbc14065% 6simon's inc xyz20070% 7simon abc9525% 8shows zbd18045%

Want it to show Names and data:

A B C D E 1mr smithxyz10020% 2mr smithabc12430% 3mr smithdef20040% 4mr smithxyz7550% 5simon inczbc14065% 6simon incxyz20070% 7simon incabc9525% 8showszbd18045%

I have one cell with $20,000 hard coded (cell A1). In another cell I want the cell to say "20,000 Capital Raise" (cell B1). And i want B1 to link to A1 so that if i change the number in A1 it will also change in B1.

Here's what i have in B1 so far: ="$"&J6&" Capital Raise"

This produces "$20000 Capital Raise" in cell B1.

So the only thing i'm trying to figure out is how to get the comma in the $20,000 so it will read "$20,000" instead of "$20000".

I need the list in column "R" to become the list in column "T" but i need to have the list update everytime a number "New" number (not already in column "T")..so if i added "37" in column "R" it would show up in column "T".

Please find the attached MS Excel 2010 file <average set.xlsx>.

There is set of positive set & negative set of values available in the Column A. The values are plotted against Column A in Column B. Light green are positive sets and light yellow are negative sets.

Now I want to calculate the average for the positive set & negative set of values as shown in light majenta in the cells F4:F9. Also all majenta cells to be plotted by formula.

The Column H and Column I also same as like above , but here negative set of numbers starts first.

A formula I am using is outputting "0" instead of the expected value. Upon evaluating the formula I realized that this was because some of the values - years, in this case - had quotes around them while others did not. Please see the image below for the screenshot of the evaluation.

These values - the years - are being evaluated in the following formula.

Code: =SUM( IF(inventory!$F$3:$R$3=$A3, IF(inventory!$B$4:$B$56=$G$1, IF(inventory!$D$4:$D$56=$G$2, inventory!$F$4:$R$56)))) This formula references the following sheet (an excerpt from that sheet). You can also see the formulas found in the cells causing the problem.

I suspect that the problem is being caused by the output of the formula in these cells. If I simply type in "2011" instead of using the formula in B52:B56, then the first formula in the code section above does not have a problem.

I need to divide the numbers on sheet 1 column D. This column contains numbers and blank cells so I need to divide by the actual number of cells that contain only numbers. I will be referencing the divided numbers on sheet 2 in a monthly summary format.

1- I dont know why but sometimes excel 2010 converts numbers to dates automatically in my workbook. I use this macro to solve the problem, but since last week it is not working. I get an error: "Method 'NumberFormat' of object 'Range' failed".

2- because it should work in all cells of the workbook, the macro must make changes only in the cells with absolute numbers (ex: 1223) but must not change if in the cell there is a date like 12-may-2012 (numbers with hyphens).

This is my function: _____________________________ Sub PuxaDatas() Dim sht As Worksheet For Each sht In ActiveWorkbook.Sheets

About descending and related to each others, I mean for example : #700 in column A,B,C,D,E,F,G,H places in the same row and the same happen to #1533.954 and others. About the numbers that are The One ( like 549.894), I need to put them in its column and a new row with empty cells in its other columns. In the end i want a table like this: