**1**

vote

**0**answers

200 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

**2**answers

56 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

**1**answer

25 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

**0**answers

31 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

**0**answers

82 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

**3**answers

79 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

**0**answers

113 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

**1**answer

61 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

**2**answers

30 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

**1**answer

40 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

**0**answers

298 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

**2**answers

42 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**

vote

**1**answer

32 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

**0**answers

40 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

**1**answer

27 views

### How to constant 0 in the range when the number is not inputed

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

**1**answer

221 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

**1**answer

92 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

**2**answers

3k 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

**1**answer

85 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

**0**answers

62 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

**1**answer

367 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

**1**answer

270 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

**2**answers

41 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

**1**answer

40 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

**1**answer

46 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

**1**answer

346 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

**0**answers

29 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

**1**answer

71 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

**1**answer

58 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

**1**answer

51 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

**0**answers

34 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

**1**answer

368 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

**0**answers

215 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

**1**answer

24 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 ...

**1**

vote

**2**answers

313 views

### How to fit mm/yyyy in SUMIF criteria

I've looked around for answers regarding this, but am still a bit confused. I have a column A in Excel with dates in the format mm-yyyy (i.e. September 1014 is Sep-14). I want to add all the values in ...

**0**

votes

**2**answers

862 views

### How to get count in pivot table that does NOT count duplicate entries

I am setting up a pivot table, and I would like for it to give me the count of the number of unique combinations of two fields, not just the total count. That is, each combination should only be ...

**0**

votes

**2**answers

131 views

### Error is using Microsoft Query data in excel in 3rd Person's PC

I have a problem when using Microsoft Query in Excel Data Link.
I have used SQL Server Connections before in Excel. When we use SQL Server, after doing the connection and retrieving the data, the ...

**1**

vote

**1**answer

141 views

### Certain Dragon NaturallySpeaking voice commands not working in Word, Excel

I am running Windows Vista, with MS Office 2007. I used to have Dragon NaturallySpeaking 10, and I noticed that certain commands, such as "Undo That, Italicize that, Bold that," etc. no longer ...

**2**

votes

**1**answer

29 views

### Excel 2007 Formula Issue - Newbie

I have a cell containing 5;9;11;13;15;17. There could be upto 15 different numbers in the cell. These numbers represent attributes.
For example 5 = Padlockable, 9 = Keylock etc. There are around 50 ...

**1**

vote

**1**answer

363 views

### Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot :
The Layout :
1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...

**1**

vote

**1**answer

55 views

### Excel formulas: Dates A, B, C and D. How many days between A and B also fall between C and D

Example:
A1 = 8/5/2004
B1 = 29/12/2004
C1 = 1/1/2003
D1 = 21/11/2004
I want to work out how many days between A and B also fall between C and D. I can't get my head round what the formula to work ...

**0**

votes

**0**answers

60 views

### Hiding the Microsoft Query table properties in Excel

I have done a data connection in Excel using the "From Microsoft Query" data connection type.
In that i have also set criteria where the values are taken from a particular cell. This is so that the ...

**0**

votes

**0**answers

39 views

### Dynamic Scenario output in excel

I have a model where in the input numbers going into the model depend on the cases/scenarios i select from a drop down menu ( Base, Best and Worst). These numbers are then used across all remaining ...

**0**

votes

**0**answers

8 views

### Splitting data in column a to column b and or c

I'm trying to find a macro that will help me in sorting data. This is a very large document and will be a regular (monthly) endeavor.
I've looked and tried help but I'm no better off, lol.
I've got ...

**1**

vote

**1**answer

103 views

### Changing a String Value to Date format in VBA

I am working on a VBA scripting in Excel. The following is the code that i am working on.
Option Explicit
Sub MoveThingsAbout()
Worksheets("Sheet3").Cells.Clear
...

**-1**

votes

**2**answers

206 views

### Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row

I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master ...

**0**

votes

**3**answers

61 views

### group values in set of 5 and then return the first value from each group

I have a long list of values of a stock in minute format. The column C shows the open values(per minute) and column F shows the corresponding close values
Now I want to covert this data into 5 min ...

**0**

votes

**1**answer

27 views

### Sort one column by another and keep proceeding rows in the same order

So I have this excel spreadsheet that has a few verbs in Spanish as well as their conjugations:
Order Infinitive conjugation1 conjugation2 conjugation3 conjugation4 conjugation5 conjugation6
ir ...

**1**

vote

**2**answers

56 views

### numbers on x-axis graph in Microsoft Excel 2007

I have a problem with a graph in Excel. Here is how it looks like
The problem is that I need the x-axis to start from 0 to 10
I am using Excel 2007. Basically, what I need is U=f(alpha)

**0**

votes

**1**answer

45 views

### Adjust sequence position of barcode scanning result

I've been improve our warehouse record method by barcode scanning.
But the problem defaut scanning result inside excel format is after scan cursor will move to below cell ( ex : A1 to A2 to A3 etc).
...