**0**

votes

**1**answer

32 views

### RIDICULOUS EXCEL FORMULA, IF [#] minus [#] and > [Date]

Im trying to create a formula for the below example:
cells A1-A15
MOS #'s 0311,0352,0341
cells E1-E15
End of Tour Dates
First I need to get the count of the MOS #'s for each SPECIFIC MOS, ...

**0**

votes

**2**answers

18 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

17 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

**0**answers

21 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

24 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

15 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

45 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

48 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

32 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

12 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

60 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

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

**-3**

votes

**0**answers

28 views

### I want to match two columns i.e. column A and Column B matching ENTIRE CELL CONTENTS [on hold]

I have one lakh Surnames (belonging to 4 different communities) in Column A
I have approx. 5000 Surnames belonging to particular community in Column B
Now I want to match data in Column B to data in ...

**-1**

votes

**1**answer

15 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

117 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

**1**answer

32 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

28 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

23 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

27 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

30 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

30 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

17 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

14 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

7 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

42 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

29 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

42 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

18 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

29 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

26 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).
...

**-2**

votes

**0**answers

20 views

### Vlookup in Excel

I have created a large data base and have built a search facility using SEARCH,RANK,COUNTIF, then using
=VLOOKUP(B7,Sheet2!A4:c518,3,FALSE)
This produces a correct reply, but if there are several ...

**-2**

votes

**1**answer

36 views

### Excel formula Countif

I have dates in one column and names in the next column.
I want the formula to count the individuals as per the date. For example, on 10/1/2014, I want how many times the name Kiran is populated in ...

**-3**

votes

**0**answers

58 views

### I want to compare two different columns and get a value from another workbook using VLOOKUP

I want a value from the workbook(2) by comparing two different columns from workbook(1) using VLOOKUP.
I want a VLOOKUP coding like, if WorkBook(1)columns A matches with workbook(2) columns A then it ...

**-2**

votes

**1**answer

53 views

### Excel, using cell text references as input for formula

First of all thanks for your help. I have a problem regarding the use of text into formulas. I am working on a huge dataset of stocks of several years. The stock are not correctly grouped. I used an ...

**1**

vote

**1**answer

28 views

### Excel 2007 formula to find out date from year and week number?

I'm trying to make my work hour notekeeping a bit easier. I note my hours by project so that Monday - Friday are in their own columns. I report my hours based on this weekly, so each worksheet has one ...

**0**

votes

**0**answers

82 views

### vba excel macro runtime error 1004

Dim lastC As Long
lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug
SourceRange.Copy
wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...

**-1**

votes

**1**answer

23 views

### How to apply formula in specific condition in excel

I am trying to use flags to use in formulas 1 ,0 . I want excel to put 1 every specific number of months (3,6,...) .
so if 1 applies in Sep ,then I want another 1 to be after (3,6,...) months. the ...

**0**

votes

**1**answer

32 views

### I need help for a quote form I am creating

Let me try to explain what I am trying to accomplish. Let's say that there are forty options available on a quote form. The customer only wants eight of the options. I would like to enter a ...

**0**

votes

**1**answer

16 views

### Page Break lines won't stay off for a shared Excel document

I have a shared Excel document on my NAS, and in Excel I go to options and disable Page Break lines.
However, when someone else opens the document, the page breaks reappear. When I reopen the ...

**0**

votes

**3**answers

62 views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**0**

votes

**1**answer

71 views

### VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...

**1**

vote

**1**answer

42 views

### Matching and updating columns in Excel from two documents

I'm completely green with Excel, whenever I think there has to be a quicker/easier way I usally just GOOGLE it and sure enough I find an answer, fab!
Now I'm trying something a little more tricky and ...

**1**

vote

**1**answer

20 views

### Is there a way to do a partial text vlookup?

I am trying to vlookup partial text which will return a specific value if found within my data. I have a list of postcodes (zipcodes) and would like a vlookup to look up the first part of the postcode ...

**-1**

votes

**2**answers

44 views

### how to cancel the focus change of cells in excel 2007?

When I move the cursor in Excel 2007 from cell A1 to cell A2, so that cell A2 is highlighted instead of A1, sometimes I press the tab key too quickly, so I try to go back and highlight A1 again.
I ...

**1**

vote

**1**answer

35 views

### Excell formula for multiple pasts without repeating previous cells

I have a data set for 12 years of 4,380 days. I want to take the sum of each week. when I make a formula {=SUM(A1:A7)} and drag to drop button to the next cell it shows {=SUM(A2:A8)}. This is not what ...

**2**

votes

**1**answer

28 views

### Pivot table with two headers in MS Excel

I'd soo appreciate if someone could help.
My initial table looks like this:
Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------
...

**0**

votes

**1**answer

45 views

### Have Pivot Chart show only some columns in pivot table

I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself. I then have a pivot table where my ...

**0**

votes

**2**answers

45 views

### Converting comma seperated values in multiple rows

I am in urgent need of importing huge data from excel to SQL.
one of the excel sheet contains data as follows.
ID Name Category Section
1 Books Stationery KG1,KG2,1
2 Pencils ...

**0**

votes

**0**answers

66 views

### Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...

**0**

votes

**1**answer

11 views

### Formula to incorporate Highlighted text & Loop function

I'm trying to analyze over a 1000 line items,
with different information in all columns ,although certain columns might have duplicate information.
I can do conditional formatting and highlight the ...