Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

0
votes
1answer
15 views

Excel formula - Return value from lower row

I'm looking for a way to search for a value in a single column and return a value in that same column two below it. Example: A1: Apples A2: Bananas A3: Oranges A4: Pears If I search for ...
0
votes
1answer
28 views

Create CSV file from Excel with delimiter other than comma?

Is there a way to create a CSV file from an Excel one, but with a delimiter other than comma? I tried changing Windows parameters. In Windows Control Panel -> Click, Language & Region -> formats ...
0
votes
0answers
12 views

Find duplicates [on hold]

I have a 1 workbook 13863 records. And I want to search these record to 73 xls works. These 73 excel files contain 800,000 records. I want search text from 1 file to 73 files one by one. And match ...
1
vote
0answers
11 views

excel 2007 MS Query

I have created a spread sheet using MS query. I have added several columns to the rows of data so there can be some manually entered notes at the end of each row. The problem is when I refresh the ...
0
votes
1answer
22 views

how to create persistent random numbers &letters in excel?

Below is link for example sheets https://docs.google.com/spreadsheets/d/1D-D29csRGAAZl_h7fyMwLJ6am0FpZAtCZ5r0XlmQVqo/edit?usp=sharing. This is a live spreadsheet, which can't be pasted in this ...
-2
votes
0answers
22 views

How do I lookup data in Excel? [on hold]

I have 2 sheets of data with more than 5 columns in each. I want to look the value in one of the column in the sheet 1 with the value in the sheet2 & retreive the the value of another column in ...
0
votes
1answer
17 views

Pad a number with prefix zeros no and decimal place in Excel?

Is there a way of formatting cells to: Add zeros to fill entered numbers that fall short of the required amount. Not round up/down decimal places but display as an entered number. For example, if ...
0
votes
1answer
56 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
-3
votes
2answers
32 views

Conditional Formatting in columns [closed]

I would like to add a format, where column B is less than column C it should be higlighted in Red.
0
votes
1answer
16 views

Excel Data Validation List as Formula in “Source” Field?

I am using Excel 2007. Is it possible to enter a short list of allowed values directly into the "Source" field in the Data Validation -->Settings Tab? If I want to allow a cell to have one of two ...
0
votes
1answer
17 views

How to Lock or password protected specific cell in excel 2010

How can I Lock a specific cell in a sheet of excel 2010 so that any one can not change or input anything in that cell?
0
votes
1answer
40 views

How to keep Excel line graph from incorporating dates that are not in my range

I have created a line graph based on dates and the values associated with those dates. However, it is inserting dates into a graph which I do not want. The dates run in chronological order, I only ...
-1
votes
2answers
41 views

formula to work percentage [closed]

I am trying to find a formula that will perform a specific function. I have two values, for example 15 and 50. 15 (b6) is the number of questions I have correct and 50 (c6) is the total number of ...
0
votes
0answers
24 views

How to optimize Excel 2007 cell width for printing?

I have an Excel spreadsheet with 5 columns. Two columns have cells which contain very little text (e.g., dates or prices) while three columns have cells which can sometimes contain several rows of ...
1
vote
0answers
27 views

Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...
2
votes
2answers
33 views

Excel formula to populate from one column only if another is empty?

I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not ...
0
votes
1answer
22 views

What is the unit of row height in Microsoft Excel?

In Microsoft Excel, Row Height is set as 15. What is the unit of 15? Is it inches, centimeters, etc.? I am trying to compare the height of the rows to a sheet of paper before I print it out.
0
votes
0answers
11 views

Auto create folders using Excel field entries (using a template folder)

I need to generate folders for new job numbers that are generated in excel. Every time the excel sheet is updated with a new job number I need to generate a folder in a set location with the folder ...
0
votes
0answers
21 views

Using icon sets comparing values in two cells (excel 2007)

I am trying to place icon sets in cels with their value, comparing that value to the same data of last month. So for example I have column A contains this months rank (0-10) column B contains last ...
-1
votes
3answers
59 views

excel if statement 0 value

I am creating an if statement which helps calculate the difference between two cells and displays the difference as a percentage- here's an example of the code I am using - =IF(D19=E19,"Values are ...
0
votes
0answers
52 views

Auto propagation of formulas down the columns for each new row

How to propagate those formulas down the respective colums for every new row automatically? There is an webhook which creates new rows with data with those columns (A1, X2, Y2) empty, and I would need ...
0
votes
1answer
44 views

Auto sequential numbering based on cell criteria with two numbering sequences and ability to ignore duplicates

In the example below the numbering in column A skips rows that have the word "TOTAL" in column C but picks right up again in the next rows. The rows with the word "TOTAL" in column C have their own ...
0
votes
1answer
37 views

Excel freezes for a few seconds

We have a strange problem with Excel 2013 where all excel options will grayed out when we use CTRL+SHIFT+END button to select all the cells. During this time we will not be able to select any cell or ...
0
votes
2answers
20 views

Excel Search from one sheet to another

I need some assistance with a search - I need to input a postal code in Cell A and if it matches a postal code I have in another tab it will return the Suburb! So - Sheet 1 input Cell A1 will be ...
0
votes
1answer
26 views

how to make a Copy formula, Value from A3 to B3 if z3 = csl

Is it possible to have a formula that can copy text value from A3 drop down list of cars, paste the text Value into B3, once i put CSl into Z3. then i can delete A3 but still have the text Value in ...
0
votes
0answers
42 views

Trying to get VLOOKUP to get data from a table array on another workbook where the worksheet name is variable

I currently pull data in from 4 workbooks using the INDIRECT function, the formula is as follows, =INDIRECT("'[" & $AE$1 & "]" & $AA$13 &"'!" & $AI$1) $AE$1 contains the workbook ...
-1
votes
2answers
37 views

Is there a way i can copy this macro i made but have it change for the next tickbox

I have made this macro to Select cell A3 copy the value and paste it into cell Y3. it then clears cell A3 as that's a dropdown box, by doing this the dropdown option can be now selected in A4. ...
-1
votes
0answers
26 views

How can i make this formula show up blank untill there is a date plz [duplicate]

=IF(G4<(TODAY()+1),"Warning - Time to Renew","OK") having trouble with =if(isblank(g4),"",g4. but then it doesn't let me add that to the start what am i doing wrong. ...
1
vote
1answer
27 views

can someone help me with my Formula Excel need it show blank

=IF(NOW()-B4>=15,"OK","Warning - Time to Renew") that is the formula, but can it stay Blank until a date is put into cell B4 thanks
0
votes
0answers
28 views

Making DropDown list without repetition, Adding name back to List?

i use this method to help me with my own Excel data for Car Hire. its working great user can select one car and until its deleted from the first field the next user can select. is it possible that the ...
0
votes
1answer
22 views

Is there a way to have a constant 0 in the cell even if no data entered?

In cell A1 I have number entered as 10. If I delete the number 10 from the cell A1 I want 0 to be constant in the cell A1 automatically instead of manual entry of 0?
0
votes
1answer
36 views

Excel, how to check cell value against a column of values?

Using excel 2007, I have 2 worksheets. The first one is 1 column of about 600 numbers/IDs. The 2 worksheet is about 30 columns for about 5000 IDs. Im basically trying to filter out the 600 IDs ...
1
vote
1answer
21 views

Is there a date-formatting bug in Excel?

This is what I've encountered recently Whenever I type 10/13 on A79 It pops out Oct-14 to me.(But other columns worked normally) These are the maximum details I can give, and please point out where ...
1
vote
2answers
31 views

Convert Text Value to Time Value in excel

I am trying to convert text to time. Basically I copy and pasted the total time of employees but it pastes as text value and then in order to add the time I have to convert it to time and I have to ...
0
votes
1answer
42 views

Need a way to have excel show items I have used already from drop down list

This is my first time asking. I have an excel sheet, new to excel but love to learn. I worked out how to make drop down lists and I have a list of cars that are being used. The user in sheet 1 ...
0
votes
0answers
38 views

need help creating a macro button in excel in order to pick up data from a selected row and use it to fill in a form on the next sheet

HI I need a macro button to take information from a selected row in excel but not all of the information in that row and use it to automatically fill in a document that is on the next sheet. e.g. ...
0
votes
1answer
39 views

Excel VBA Date format: Hyphen as separator gives wierd substitution result

Excel 2007. I want a macro to put today's date in the current cell formatted as dd-mmm-yy, e.g. 30-Oct-14. The code I have is simple : 'ActiveCell.Value = Format(Now(), "dd-mmm-yy")' For some ...
0
votes
1answer
76 views

Auto Sequential numbering based on cell criteria - create two independent automatic numbering sequences

How to make the numbering in column A skip any rows that have the Word "TOTAL" in column C but pick right up again in the next rows? At the same time can the rows with the word "TOTAL" in column C ...
0
votes
2answers
22 views

Excel Highlighting First Empty Cell Below An Entry

I've been trying for hours what I thought would be simple but clearly is not for me! I have a column where every ten cells has the word "TRUE" in it, the rest of the cells in between are empty. So it ...
0
votes
1answer
21 views

How can I return corresponding value from Master List by comparing Child List?

I have 3 columns MasterList, Value and ChildList. Now I want to compare Childlist against Masterlist and get the value from corresponding MasterList. I have below values in worksheet. MasterList ...
-3
votes
1answer
27 views

Lookup that Use a cell that contains range as lookup value and lookup vector

Sorry, I can't post image here because of restriction. But, I can't find another way to explain my problem. I have a sheet like that. And then, I need cell B5 to return a value based on data from ...
2
votes
1answer
53 views

How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows: Unknown Very High High Medium Low Very Low None I like the visual cues provided by ...
0
votes
0answers
16 views

Continue from one excel sheet to other without merging them together

i have an Excel workbook whic contain monthly sheets of sales. Each monthly sheet contains sale figures for various items (in columns) on a daily basis. the days are grouped in weeks. Now i want to ...
0
votes
1answer
53 views

Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...
0
votes
1answer
50 views

Lookup Values Based on Values in Other Cells

I have an inventory list that contains a manufacturer name and product category for each product. I want to look up the code for the manufacturer and the category code for the product and place the ...
0
votes
1answer
35 views

in Excel, Can I replace “sheet1!” with a formula?

I have 100 sheets named as 1,2,3....100 then in each sheet, there's a value in cell A1. I am building a summary sheet now, in the summary sheet, I want A1 = 1!A1, A2 = 2!A1, A3 = 3!A1 ...... A100 = ...
0
votes
0answers
16 views

save a sheet in new closed workbook without links

I have this code which work pretty good but I have a problem that the new exel workbook have links from the old one. Sub archive() Dim FileExtStr As String Dim FileFormatNum As Long Dim xWs As ...
0
votes
1answer
101 views

Plot two time series with same start and end time: data does not align with axis

I'm trying to plot graphs for pressure and temperature recorded on different devices. The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...
1
vote
0answers
53 views

Macro to copy multiple rows from one worksheet to another and then copy the headings into copied columns

I am new to macros and I have developed this macro that allows me to take rows that has data in them from cells B-G from Workseet "master 1" starting from row 11. I take this data and then copy it ...
-1
votes
1answer
16 views

populate cells from another worksheet

I need to populate a worksheet with a calculation based on 2 cells in another worksheet within teh saem workbook. In worksheet one I have a table with 'Last Month' and 'This Month' that contain ...