0
votes
1answer
16 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 ...
2
votes
1answer
23 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
1answer
42 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
47 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
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
0answers
47 views

Plot two time dependent series in Excel 2010 when the number of data points are different but start and end time are same

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
votes
1answer
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
2answers
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
2answers
27 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 ...
2
votes
1answer
26 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
1answer
28 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
1answer
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
0answers
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
0answers
13 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 ...
1
vote
1answer
40 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
2answers
28 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
3answers
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
1answer
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
2answers
28 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
1answer
24 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). ...
-3
votes
0answers
57 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
1answer
50 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
1answer
26 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
0answers
73 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
1answer
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
1answer
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
3answers
59 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
1answer
65 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
1answer
19 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
2answers
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
1answer
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
1answer
27 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
1answer
43 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
2answers
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
0answers
58 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
1answer
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 ...
1
vote
2answers
52 views

Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet. First Sheet: (yes I need these merged cells) Second Sheet: Unfortunately Google ...
0
votes
2answers
29 views

Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...
0
votes
1answer
30 views

Combining Two Differently Formatted Spreadsheets

I'm relatively new to excel and am having some issues comparing two sheets of data. We're looking at the benefits over the fiscal year by month. One spreadsheet has the project ID on the left, and the ...
2
votes
3answers
38 views

Problems figuring out weekly scheduling and hours past midnight

This is a screenshot of what I have What I'm trying to do is have the hours for each individual person posted as shown or a way that the hours can be posted like this and then have the total amount ...
3
votes
3answers
126 views

Excel Scheduling - trying to calculate hours after midnight so they're not negative

If anyone can give me any type of help on why I have negative numbers instead 40, which is what it should equal please help. I'd be so grateful. Thank You!
1
vote
1answer
77 views

Excel - Parsing data to template

I'm not sure if this is possible in Excel. I have a sheet that looks like: +---------------+-------+--------+-------+-------+-------+-------+-------+-------+ | | August ...
2
votes
2answers
39 views

SUMIF/ COUNTIF (look up names from column 1 then sum numbers from column 2)

I need to look up names from column 1 then sum numbers from column 2. Some names in column one appear more then once. (The spread sheet I am working on has 7400 rows!!!) Example: Column A ...
0
votes
1answer
49 views

Excel - How can I collapse data, eliminating blank rows?

I have a 3 column, 20 row table. (A1:C20) The 3 columns are each 1 digit of a 3 digit number. Some of the rows have 3 digits, some are blank. I need a way to return all the non-blank rows of 3 ...
-1
votes
1answer
29 views

Formula to return values into a number of cells based on another cell's value. [closed]

If I have a cell (A1) value is "2" (set value) & another cell (A2) value is "4" (number of cells in 1 column i want the set value to appear in) How do I return the values in B1:B4 to all be "2"?
0
votes
1answer
29 views

Financial Quarters from date

I have looked around for other solutions to this issue using the =ROUNDUP(MONTH(A1)/3,0) code. However I am not using the standard dates for Quarters Q1 - 02-Feb/03-may Q2 - 04-May/02-Aug Q3 - ...
0
votes
0answers
37 views

How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data. Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...
0
votes
2answers
39 views

How can I find max value for a text as unique identifier in Excel?

This is basically for an auction setup in Google spreadsheet. Say there are 26 bidders A to Z and each bid 5 times with different values. I need to find the max value bid by each of them and display ...
2
votes
2answers
1k views

How do I get “yes” or “no” in Excel if the information comes from “true” and “false”?

first of all, I have to point out that I am a German visiting this forum (I couldn't find anything useful on the German websites), so excuse my English if it is bad here and there ;-) Here is my ...
-1
votes
2answers
98 views

Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item. Here is the data table: Date Item Quantity Operator 01/01/2014 Item1 3 John 01/01/2014 Item2 5 ...