I have column "A," and "B," with random numbers listed. I need a formula to add just the even numbers in column "A," and all the odd numbers in column "B."
I.E.(Range A1:A10 & B1:B10)
I work for a charity and I have to cancel the donations of people whose credit card donations have been declined in three consecutive months.
If in Column A I have a list of donor IDs whose credit cards were declined in Jan 2008, in Column B I have a list of donor IDs whose credit cards were declined in Feb 2008 and in Column C I have a list of donor IDs whose credit cards were declined in Mar 2008, is there a way of showing in a fourth column which donor IDs were common (repeated) in Columns A, B and C? I would have a title for each column in A1, B1 and C1, and also the column where the repeated donor IDs would be displayed.
I need to compare two colums by number decription for example m344 in one column and fsh344-1 in another. All I want to match is 344. In column a I want to indcate the match by placing an X by each match. View my attachment for reference. I don't know if it makes a difference but the columns are centered in my original spreadsheet.
View 8 Replies View RelatedTrying to write odd numbers in a range of cells. below just writes the 1st cell in the range repeatedly up to 23. i want to write the 1st cell as 1 the 2nd cell in the range as 3 etc. Seems simple enough but if i move the "For i ..." & "next i" to where i think it should be to achieve this, it errors out.
View 4 Replies View RelatedIn column A I have a list of numbers 1-1000
In column B I have a unique set of numbers that correlate to column A by row.
In column C I have another unique set of numbers, with each cell having 2 numbers in it separated by a return. Some instances have arrays and multiple numbers separated by commas, but those are less important.
I would like to figure out a formula that will take each number in col C, find the same number in col B, and then return the number adjacent to it in column A, or equal to the row number, ending with the results in Col D. Sample results in col D of attached doc.
sample correlation.xlsx
how to create a formula to sum the top 10 numbers of column C only IF Column A contains cell reference D1, and Column B contains cell reference D2.
Column A is all text colors
Column B is all text vehicles
Column C is all numbers
Column D1 contains the word RED
Column D2 contains the word CAR
I have used two cells to do this when column A is RED, however i cant figure out how to add in a filter for Column B (D2 CAR).
1st column cell E1 contains: =LARGE((A:A=D1)*C:C,10)
2nd column cell F1 contains: =SUMIFS(C:C, C:C,">="&E1,B:B,"="&'Sales Summary'!D1)
formula thats easier or able to filter for the above?
What's the fastest way to display the sum of each column in one row. Here's a picture of what I want to do: http://www.filefreak.com/ppublic/33833/excel%20help.bmp now I want the sum of each column to be displayed in for example row 10. I have tried manually clicking "autosum" (sp?) but that will take a lot of time as I have about 400 more of these.
View 2 Replies View RelatedI have 3 columns; A:Name, B:Debit & C:Credit. There are multiple row (approx 15,000) where I have a customer name and then a debit at one date, and a credit at another date. There is a debit to match every credit.
I would like to some how sort the sheet so that I can make sure each credit matched the debit. That way I can find what debit's don't match the credits. This is an example of how this looks. http://i303.photobucket.com/albums/n...kejoe/sort.jpg. I would like to sort it like the example on the far right (see attached picture)
I have a column with all different numbers. I need to add 3 to each number. Ex. 12.46 needs to change to 15.46. This can be done in the same column or a different column. Doesn't matter. I just need to add 3 to each number in the column. Right now I'm typing them in :o
View 4 Replies View RelatedI am working on a spreadsheet and could use some help
I got a sheet where I need to pull the numbers listed under the columns
for example I have cut and pasted my data below. It did not paste well however I think you might be able to still figure it out.
I need to know how many Game 1's are being played in each week
and I need to know how many Game 2's are being played in each week.
TeamsGame 1Week #Game 2Week #Game 3Week #
Florida GatorsTroy2Tennessee3At Kentucky4
Texas LonghornsAt Wyoming2UTEP4Colorado6
USC TrojansSan Jose State1At Washington3Washington State4
Oklahoma SoonersTulsa3Baylor6Kansas State9
LSU TigersAt Washington1Vanderbilt2UL Lafayette3
How do I get Excel back to letter column headings and normal A1 cell references rather than C1R1?
View 2 Replies View RelatedI have two columns that each contain about 100 serial numbers. Most of the serial numbers shoud be in both columns. How to I determine if there is a serial number that is only in one of the columns and not in the other?
View 4 Replies View RelatedI have a column with random times that are not seperated by any commas or spaces how can i seperate them into different columns. For example in A1 i have 12:3213:5420:32 this represent three different times 12.32 13.54 and 20.32 (each time has the same format as shown) and i want to display these as B1=12:32 C1=13:54 and D1=20:32 then do the same for the rest of column A?
View 3 Replies View RelatedI have the following columns (O & S):
S O
-----
1 3
3 7
6 6
8 4
1 3
2 8
1 6
I want a code (Formula) do the follwoing: Matching number 1 in column S with number 3 in Column O and count how many matches found in the two columns, Which in this case only two.
I have 2 columns of data (Column A and Column B).
I would like to be able to search the two columns and see if any of the data repeats in either column. Here's an example:
15844721565538
15907771565575
15936501574897
15946991576501
15970061576502
16095501578841
16124741578842
16124781578843
16124821578844
16166161578954
1616781 1616781
The list is much longer than this. I need a formula or whatever that would scan both lists and say, nothing matches, or 1616781 matches or highlight the matches or whatever, just so long as I don't have to go down the entire list multiple times.
I would have downloaded Htmlmaker and provided a glimpse that way, but the web site is blocked here at work.
I have account numbers in column A. I have 2 columns which contain account range.For example column/cell f1 contains 45555555 and column cell g1 contains 45666666. I have to check if the account in column A is in this range, and if yes ,I have to have "klo" in column B.
The problem is , that I have to check a lot of rows (and I do not mentioned but I have to check other attributes with the same structure as well) and the do- loop-if structure is rather slow. Could you tell me how can I solve this with say arrays-or with other method-which can boost my macro?
I would like to multiply every number in one column with every number in another column with every number in a third column (columns A,B and C).
There are less than ten cells in each column.
i need to calculate the median of numbers in column m. which numbers i want to include will be calculated by checking their number in their row in column a.
so.. column a is ages of surveyees, column m is how long they sleep per night. i want to calculate the median sleep per night of 9 year olds.
I want Excel to compare two columns of numbers. Column R has 1000 entries,
beginning with the number 1 and ending with the number 1000. Column S will
have from approx. two hundred to as many as six or seven hundred entries,
looking something like this: 3, 5, 6, 10, 11, 13, 14, 15, 18 . . . . . . 990, 992,
995, 996, 999, 1000. I want Excel to compare column S with column R and
display the difference in Column T. Column T will therefore look like: 1,2,4,
7, 8, 9, 12, 16, 17, 19 . . . . . 899, 991, 993, 994, 997, 998. I have to do
this multiple times, does Excel have a built-in function(s) that can do this or
do I need to write a macro? The numbers can be formatted as text if neces-
sary
I am trying to find some number which i have from a list of numbers available in various rows, for eg
11
7
11
13
17
i am tryng to find 11,13,14,15,16.... 38 from columns given i.e. 7,11,13,17....
MR EXCEL EXAMPLE.xlsx
I'm trying to create a sumif or sumifs function that will add numbers from two columns. I've attached an example (semi populated as needed to get rid of some personal data so ignore the ref notes). On the Category Worksheet I'm trying to get column D to sum info from the March Worksheet. I would like the function in the Category Sheet to add Columns F and Columns H from the March Worksheet if they correspond to column A22 on the Category Worksheet i.e, the result of the data I've left on this example sheet should be $20....... sum of F = -130 + sum of H = 110
I need to organize some unorganized texts in my columns.Here is what I have in the column:
STARMERBRIEANA 134 CRICKLEWOOD AVE HENDERSON,NV 89002 CLARK Home - ( ) - Work - ( ) - Ext.
Here is what I need it to look like:
Column B = "134 CRICKLEWOOD AVE HENDERSON,NV"
Column C = "89002"
Is it possible to use numbers for columns in place of letters? If so, can you specify the starting number?
View 2 Replies View RelatedJust got an answer to my phone number problem of converting two columns of numbers
to a single columns with the form XXX-XXXXXXX. Used =A1 & "-" & B1.
Works perfectly one one spread sheet and not at all in another.
When I enter the formula and hit return, instead of the correct result, all I get is the formula.
The format of the columns is the same on both spread sheets.
How I can know the numbers of rows and columns in a excel sheet?
View 5 Replies View RelatedI have to separate text & numbers in different columns.
e.g. 349,910 American Capital Ltd. (a) 4,902,239
i want all 3 data in separate columns, there is a series of data like this wherein numbers are there both at begining & end & text in middle.
I am attempting to create a chart from data generated outside of Excel 2003 SP2, that has been Copied and Pasted into Excel. There is no metadata associated with this data. I have created a list with the data once it has been pasted into Excel 2003 SP2.
The Workbook has five (5) worksheets, all with the default names (Sheet1, Sheet2, etc.). I paste the data into Sheet1 and reference this from the other worksheets. Sheet2 shows the charts for all the data. Sheet3, Sheet4, and Sheet5 are each for different regions, North, South and West respectively. I would like to enter the formula into Cell: Sheet5!M5 so it auto populates with the appropriate and correct information. Sheet1 information is as follows;
Column B has a header of "CreateDate" and is in the format of; 4-Jun-07
Column O has a header of "Business Unit" and has three (3) possible answers, North, South or West. **I have attached a screen shot of the two colums used named, "Columns.Used.png". I have hidden the columns in between as they contain confidential information.**
I would like a formula that gives a total of one if both criteria are met. The criteria is as follows;
IF Column B on Sheet1 equals Cell L5 on Sheet5 AND Column O on Sheet1 equals West THEN the total should appear. **I have created and attached a sample spreadsheet "Sample.Data.zip"that contains only basic data on Sheet1 and Sheet5 as those are the only sheets relevant.**
I want to show the number of weeks remaining from the sum of a column BUT I want it to distinguish between the entry in another column.
See below.
Columns B to L represent a number of weeks
EG1
Column C: Year 1 has a set amount of 47 and C156 displays this.
C157 should display the amount of weeks in Column C but only when a number "1" appears in Column "Y" C158 displays the total amount remaining
EG2
Column H: Year 2 has a set amount of 38 and H160 displays this.
H161 should display the amount of weeks in Column C but only when a number "2" appears in Column "Y" C162 displays the total amount remaining
My columns became numbers instead of letters. How do I switch it back to letters?
View 5 Replies View RelatedI want to do is take this kind of thing all from one column:
COLA
1 blah blue
green
13 black grey brown
and put it into two columns, one with only the numbers, and the other with only the text.
COLB
1
13
COL C
blah blue
green
black grey brown
Also, I want to be able to then take that data from COL B and C and have it raw so that I can edit it easily by simply selecting row3 in COLB and change it from 13 to 4 (or whatever.)
