how do i make a number list. i want to start at 8000 then i want excel to auto generate up to 9000. it will take ages to sitt and punch 8000 8001 8002 ......
Next problem
how can i sett that cell A1 is connected with B1. so when i sort by number it follows. Example:
how can i extract all number values from a table column and list them on a separate worksheet? there are blanks in the table column, which have to be omitted.
View 14 Replies View RelatedI have a few hundred cells that I would like to combine. Each cell contains a six digit code number. I would like to combine the cells with a semicolon and a space between each code number.
I can do this with the CONCATENATE function but it will take too long.
Make a Data Validation dropdown list that also enters a range for cells, for example:
Kitchen ¦ High ¦ Upto 100 ¦ Easy ¦ Blank ¦ 2 ¦ Daily ¦ >6 hrs ¦ Medium ¦ >1 week
Lounge ¦ Low ¦ Large ¦ Easy ¦ Blank ¦ 0 ¦ Daily ¦ >6 hrs ¦ Medium ¦ >1 month
Bedroom ¦ Low ¦ Large 100 ¦ Easy ¦ Blank ¦ 1-3 ¦ Daily ¦ 1-3 ¦ Low ¦ >1 year
Bathroom ¦ High ¦ Upto 100 ¦ Easy ¦ Blank ¦ 0 ¦ Weekly ¦ 1-6 ¦ Low ¦ <1 year
I can make a dropdown list for:
Kitchen
Lounge
Bedroom
Bathroom
But if I select "Kitchen" I would like it to enter the rest of the cells in that row:
Kitchen ¦ High ¦ Upto 100 ¦ Easy ¦ 2 ¦ Daily ¦ >6 hrs ¦ Medium ¦ >1 week
The total number of rows I use is 10, and the number of items in the dropdown list will be 30.
The data in the cells 2 to 10 does not change from that first set to its data menu name.
I have two columns of numbers. The first is the area code and second is the phone number. How can I combine the two columns to make one with both: as in area code-phone number?
View 3 Replies View RelatedSay I have (cell A1) 10 salespeople and they each sell a (A2) $100/month membership, so I have (A3) $1,000 monthly revenue.
(A4) is an assumption about how many months the average person will stay a member.
So if A4 = 6, (6 month membership assumption) how would I get Excel to output $1,000 (the result from A3) into cells B3 through B8
but then for instance if A4 = 3 (3 month membership assumption) it would only output the the $1,000 result from A3 into cells B3 through B5
So like A1 through A4 of...
10
$100
$1,000
6
would output $1,000 into B3 through B8
but
10
$100
$1,000
3
would output $1,000 only to B3 to B5
I need to figure a way to make to cells with dates equal each other if the
day,month and year are the same but are placed into a cell at different times during the day. "Making Date Now () = (06/29/09) In another cell". Therefore, A1= Now() and E11 = 06/29/09
I have my dummy data, and I have (what I think) is how I want the data to be shown. My friend uses Google Sheets, but I prefer Excel. I am trying to convert the code because I am a stickler for excel. Typically I can convert codes some easily, but this is way beyond me.
For Column A: I want to create a list on sheet 'Setup!' based on ids!D2:D="yes". If that list has duplicate entries, I would like only the first entry to show up, but for the next entries I would like the cell to be blank. (this is important for the next step) For Column C: I want to have the corresponding dates go with the name entry. For Column D: I want to have the notes go with the corresponding date entry. (I believe I can manipulate Column C's code to do Column D myself).
I am also going to upload a data sheet, and an expected results sheet.
unique list.xlsx
i have many excel workbooks in a folder i want a macro that will get the names of all the files and make the file names so extracted as a hyperlink to open the files.
View 1 Replies View RelatedI am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange
etc.
Is this possible within Excel 2003?
Basically I have a giant list (50,000+) of area codes (like 312, 216, 517, etc...) and I would like to make a new column right next to that, which takes those area codes and transcribes them into states so it would be (IL, OH, MI, etc...)
I have a table on the 2nd page of my excel workbook which has every single area code listed in column A, and in column B it has all the state symbols. I got it from here: .....
A
B
c
d
[Code]....
So the data I put in Is Cells A to D the reast are calculated for me. so for example E2 is looking down column D to see if the number matches the number in A2, If any of them do it will put the name in the corresponding cell in E2 (Or you ca use a different cell if you prefer) so in this case D3=A2 so B3 is the answer also in the cell next to it I need whatever number is the cell next to the answer so in this case C3
I have a list of 200,000 e-mail addresses in a excel document in column A. What i am trying todo is find all the duplicate e-mail addresses within the list that appears more than four times.
I have tried this forumla in colunm B so it lists how many times the record appears: =countif($A$2:$A$244270,A2) which works fine and then a number appears next to each record. Then i pressed the sort filter to arrange all the records in number order so all the 5's are at the top of the worksheet but that does'nt always list them in the correct number order.
Basically all i want todo is find all the records that appear in my list more than five times then make a list of just one of those 5 records so i can remove them from my e-mail system.
Basically I have a giant list (50,000+) of area codes (like 312, 216, 517, etc...) and I would like to make a new column right next to that, which takes those area codes and transcribes them into states so it would be (IL, OH, MI, etc...)
I have a table on the 2nd page of my excel workbook which has every single area code listed in column A, and in column B it has all the state symbols. I got it from here: [url]
How would I go about making this new column on page 1 of my workbook which takes all the area codes I have and makes a brand new list of the states by looking up the area code/state table I have on page 2 of the workbook?
i am looking for excel custom number format for 0 (zero) number that make center alignment..
for example ;
sample (when type 0 (zero) number)
after custom number format
- (right alignment)
- (center alignment)
how make center alignment with custom number format for 0 (zero) number..
I am trying to combine data from multiple worksheets and make a chart. I have about 200 keywords in every worksheet (about 50), and some of them repeat themselves through worksheets and some don't. For every keyword, I have an associated value in the next column that I want to portray over time (each worksheet is for a different period).
So what I need to figure out is how to be able to pick any 10 keywords from the worksheets and put them in a line chart where I can see the associated value for each period for every worksheet so I can compare my keywords' efficiency. The tricky part is that some worksheets do not contain the keyword and other worksheets contain the keyword in a different cell than the previous wsheet.
I have a numerical value in cell B2 , and a drop list that contains unit names.
I am looking for VBA to see which unit is selected in the drop list, and then add B2's value to that particular unit's total.
See attached workbook : oz_addition_example.xlsx
I have a list of names in column A, don't know how many different names but for sure some of them repeats in different cells of column A.
A1 = NAME_1
A2 = Alan
A3 = Ben
A4 = John
A5 = Alan
A6 = Kevin
A7 = Mark
A8 = Dominic
A9 = John
A10= Tom
A11=Alan
A12=Frank
How can I make aonther list in column B, which contains a list of name in column A without repeating. So that B1 = NAME_2, B2:B4 is exactly like A2:A4, then B5 = Kevin, B6 = Mark, B7 = Dominic, B8 = Tom, B9 = Frank.... and so on. Another question, which is very similar to the previous one. In the same column A, now I add an AutoFilter (Data > Filter > AutoFilter) in A1. A drop down arrow button will appear at the right side within A1. Click the down arrow and another box shows: Sort Ascending, Sort Descending, All, Top 10, Custom, Alan, Ben.... the rest of the data in Column A but each unique data will only shows once in that list. How can I copy the contents of that box?
I am trying to setup a number of cells with a validation list allowing "Yes" or "". I would like the cell value to equal 1 when "Yes" is selected. Is this possible without VBA?
The reason for this is because I want to set up conditional formatting with the tick, cross, exclamation mark icon set (With a tick appearing for "Yes"), but this conditional formatting only works with numerical values.
I have used the formatting option to make numbers that once appeared as 1, 2, 3, 13, etc into four digit numbers, to appear as 3001, 3002, etc.
The problem is, I have other data whose original values are the 3000 formats, and Excel won't combine the two or sort them correctly.
Is there a way I can format it to change the actual value?
I want to combine number in one row.
Column A
12
13
14
15
Need to be in column B. 12,13,14,15. I tried “=A1&”,”&??
I am kind of new to Excel programming and would like to know if there is a solution to my problem. What I need is to have a dropdown list (I know how to make this) then select an item from the drop down, then based on the name i select, Excel automatically fill up the rest of the cells.
For example, from the drop down list I select the company name then Excel automatically type the address, phone number, Fax number and the contact name of the company for me in corresponding cells. Is there a way to do this?
I am looking for a formula or something - that when a reference number is used - it popluates cells from a list. Attached is a sample spreadsheet - 2 worksheets are being used - 1 is Purchase List and the 2nd is Fax Commitment. When reference no is filled in on the Fax Commitment sheet and it = the same reference no as on the Purchase List - I need it to populate the appropriate fields (in this case I have colour coded)
View 3 Replies View RelatedI have a Sub that calls 8 other subs, can I hide the 8 subs on a users macro list?
I tried making the 8 subs "private subs", and it did hide them, but then my call sub macro didn't work.
Any thoughts?
I have a formula that computes the row number in B58. I would like to combine the row # in the formula after M_MAN!A1015 for eg M_MAN!"&B58&" instead of having to type this. I can then use the foormula to copy the balance of the formulas
=-SUM(OFFSET(M_MAN!A1015,0,22),OFFSET(M_MAN!A1015,0,23),OFFSET(M_MAN!A1015,0,24))
Workings  BC57Row #Quarter5810150Spreadsheet FormulasCell
FormulaB58=ROW(HC_MAJOR_EXP)C58=-SUM(OFFSET(M_MAN!A1015,0,22),OFFSET(M_MAN!A1015,0,23),OFFSET(M_MAN!A1015,0,24))
I have a data that looks like this
P50101
181.0
89.2
19.94
12/18/06
KK
P50101
177.0
75.9
22.26
11/26/07
KK
[Code] .......
I need to enter this into spss so I need it to look more like this e.g. grouped by the first column
table { }td { padding-top: 1px; padding-right: 1px;
padding-left: 1px; color: black; font-size: 11pt;
font-weight: 400; font-style: normal; text-decoration: none;
[Code] .......
I have 2 sheets with a list of account numbers and values on each (Column A = AccountNumber, Column B = Amount)
I want to combine this on Sheet3 which should include all accounts on the other 2 sheets. Some AccountNumbers only exist on on one of the sheets.
Sheet1
A..100
C..200
E..400
Sheet2
A..200
B..100
D..200
Sheet3
A..100..200
B.....0..100
C..200..0
D.....0..200
E..400..0
I'm trying to have a drop down list in a spreadsheet which combines the info from two columns.
For example:
A B
1 John 29
2 Sandy 40, etc
And the drop down list turns into
John 29
Sandy 40
Is this possible?
I have two columns of data and would like to generate a new list showing unique combinations of those values (see attached sheet).
unique list.xls
I have a global list in B column and I want to create a text about the list. If I put "1" in A column, I want my text to be on B11 for the selected items. So excel should do a loop for the selected range and combine the selected items in a new line and give me as an output.
You may see the picture Untitled 1.jpg