# Tagged Questions

**0**

votes

**1**answer

8 views

### How to update range of columns in excel

I have an excel sheet where from one sheets's Id used as reference in next sheet.
The Id's are sequential. Like this :
Sheet 1 Sheet 2
ID Name ID Sheet_1_ID Text
1 ...

**0**

votes

**0**answers

14 views

### Why am I unable to sort data in Excel?

Spreadsheet here: Summer Invoices.
I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not).
I have checked for filters.
I ...

**0**

votes

**1**answer

15 views

### multiple entries from existing excel file

our customer provides us with an excel file listing drivers names and the number of tickets they get for a free drawing, such as "bill smith (next column) 17 tickets
is there a way to take that and ...

**-2**

votes

**0**answers

19 views

### Display formula result only if inputs are defined

I have a simple spreadsheet, with one row of equations to get sums or differences. What I'm trying to do is enter an equation so that if only one part of the end equation is present, the field is left ...

**0**

votes

**1**answer

8 views

### Add a series to a chart by pasting its formula no longer works in Excel

I used to be able to add a new series to a chart by typing or pasting a =SERIES() formula into the formula bar when a chart's PlotArea was selected, as indicated here: ...

**-1**

votes

**0**answers

13 views

### MS Excel 2007 Copy Range Across Worksheets and Increment or Offset by 50 rows

I'm looking to copy and paste a list of names from Sheet 1 to Sheet 2 but space them out. For example, I'd like Sheet1!A6 -> Sheet2!A51, Sheet1!A7 -> Sheet2!A101.... Sheet1!A41 -> ...

**0**

votes

**1**answer

11 views

### Excel - How to add/remove a row without affecting formula in a column

I have column B with a formula full of IFs with each cell referenced to the cell above it.
From time to time, I need to delete some rows. Once a row is deleted, the formula in column B gives #REF for ...

**0**

votes

**0**answers

17 views

### How do I consolidate values in excel

I need some help with an EXCEL command.
I have a large data set that contains multiple expenses of multiple individuals over time. What I want to do is to consolidate the costs of individuals per day. ...

**0**

votes

**0**answers

11 views

### How can I calculate the grouped averages and maximums per day for a range of dates and times?

I have a CSV dump describing the utilisation percentage of some servers in my organisation, covering data samples from several times per day. Each server belongs to a group. For each group, I have to ...

**0**

votes

**0**answers

10 views

### How do you create a mail merge from excel in microsoft word and then overlay multiple images on top of each other

I know how to insert images into mail merge in word one at a time and have them next to each other, but I want to mail marge three images each onto a printable label.
The first image is a background ...

**0**

votes

**2**answers

35 views

### Generate 4 columns of data such that each row sum to 100

If I wanted to randomly generate 4 columns of positive numbers such that the numbers for each row sum to 100, how do I do this in Excel or some other program that you can recommend?

**0**

votes

**0**answers

12 views

### Avoiding duplicate rows in an EXCEL Pivot Table

I am running EXCEL 2007 and try to do a Pivot table.
The data are the following ones:
And the table pivot result:
As you can see, I have some duplicate lines in the pivot table that I don't ...

**0**

votes

**1**answer

13 views

### Bit.ly link without http://

I am creating bitly links and want to save them in an Excel spreadsheet.
When I copy and paste them I get the http:// component of the address in front of the bit.ly
How can I not get this as it ...

**-2**

votes

**0**answers

18 views

### Need advice on Excel project! How do I embed an image and what is a “marker”?

I'm building a spreadsheet for certain historical sites, collecting data on it, and etc. This is what I need to do next.
"Use Google map to locate the sites. Please take a screen shot of the map ...

**1**

vote

**1**answer

19 views

### Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure:
text, text, 01/27/2001 01:00:00 PM
I need to update ALL csv files with this datetime format:
text, text, 27-Jan-2001 13:00:00
Is there a known ...

**0**

votes

**1**answer

11 views

### Excel adding rows based on if they are a number

I'm trying to add rows in a column based on whether or not they are a number.
Some rows are numbers and some are not.
I have something like the following. But it's not right:
...

**0**

votes

**1**answer

13 views

### how to get cell number as a result of a function

i need to get № of a cell that contains the result of MAX(J4:J24) and write a word from the same row instead of the actual max number
the word can be written i guess via =INDIRECT("A"&formula ...

**-1**

votes

**1**answer

18 views

### Get differences between two Excel 2007 rows, showing relative changes in second column

I want to create a spreadsheet where column A has a list of numbers and column B has the totals. I want to create a formula where the difference between each cell in column A is displayed in column B, ...

**0**

votes

**0**answers

9 views

### Named Views for Excel Pivot Table?

While I'm an advanced Excel user and developer of addins, I apologize that I'm not very familiar with pivot tables.
I have a simple pivot table worksheet based on a simple set of data in another ...

**2**

votes

**1**answer

35 views

### Remove a known Excel password without Excel

Is it possible to remove a known password from an excel sheet if excel isn't installed on the machine? We receive uploaded excel files (2007 and 2010 format) and we know the password for those excel ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

19 views

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

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"?

**-1**

votes

**1**answer

11 views

### Fixate scroll in excel

How do I "fixate the scroll" at line 27 as khan did in this excel spreadsheet?
https://www.khanacademy.org/downloads/buyrent.xls

**2**

votes

**2**answers

18 views

### Moving Right When Dragging Formula Down

I have a SUMIF formula as follows: =SUMIF($B$2:$B$5758,">1",N$2:N$5758)
Is it possible to make it so that when this formula is copied down the formula becomes =SUMIF($C$2:$C$5758,">1",N2:N5758) ...

**0**

votes

**0**answers

21 views

### Keep header text in Excel, but change font

I've seen several examples for changing the header font in Excel; however none of them just change the font. They seem to always incorporate static text or a cell reference. How do I change just the ...

**0**

votes

**1**answer

32 views

### Is there a formula I can use to count the number of occurrances of a name in 1,2,3 order?

I have an excel spreadsheet containing a list of names and "scores" that they have received for a specific date. Each name should have 3 scores each month and I'm looking for a formula that can help ...

**0**

votes

**0**answers

11 views

### Lines over data in Excel 2013 Scatter Graph

I'm having some problems getting the plot order in a Excel 2013 scatter plot right. One series should have markers ("raw data") which should appear below series with markers and line ("fit"). The ...

**0**

votes

**0**answers

30 views

+50

### Scanning, OCR and adding the scanned numbers

I need to scan hundreds of pages with numbers written on them in the bottom right corner. Post scan - I need a OCR software to recognize the number written at the bottom right corner of each page and ...

**1**

vote

**2**answers

27 views

### Excel TRUE/FALSE IF formula

I have a "Pass" column (A) and a "Fail" column (B) in one worksheet. I have a column in another worksheet where I need the following to happen:
If A is true and B is false, return "Pass"
If B is ...

**0**

votes

**1**answer

18 views

### Running a set of data through multiple calculations and outputting the results back on the data sheet

Using Microsoft Excel 2013.
I am creating a calculation sheet for quickly evaluating the metrics of rental properties. I have a sheet called CALCULATIONS with several calculations, and several ...

**0**

votes

**0**answers

24 views

### Can't change column width in Excel

Trying to drag column to change width...as I've done for 30 years. Suddenly, no more dragging. Instead, a pop-up menu where I'm given the option to manually set the width (but can't, because ...

**0**

votes

**0**answers

9 views

### Saving Excel to fixed Width format - extra tabs

I have a VBA macro that takes a spreadhsheet and turns it into a fixedwidth format in another sheet using the first column only. When I save it, it always seems to have extra tabs in the text file at ...

**0**

votes

**0**answers

22 views

### excel - ask for input to be used as new cell values

I use excel 2007 and I want to create the following function:
At first I need to add a vba function button that prompts the user to add four different values, e.g. a name, a number, a date and an ...

**0**

votes

**0**answers

29 views

### how to perform operations between sheets in excel

My question is very easy and I'm sure there is already an answer somewhere but I don't know the correct keywords when searching for them.
So here is the question:
In column C of sheet2 I want to ...

**0**

votes

**1**answer

15 views

### How to get a cell to display a value from one column when the values of another column go above a certain number

I am doing a breakeven analysis and want to know what formula i can type into excel so that once my income column reaches my breakeven point it shows what date that breakeven point was hit. The dates ...

**0**

votes

**2**answers

39 views

### Excel auto fill repeating the same number

I'm taking the difference of some figures and having trouble amending the figures to reflect what the formula is doing (screenshot below). The autofill function is repeating the same number for the ...

**1**

vote

**0**answers

16 views

### Can I modify Excel Online share URLs to open to a specific worksheet?

When I generate a share URL in Excel Online, it takes the following form:
https://onedrive.live.com/view.aspx?
resid=<DOCUMENT ID>&
ithint=file%2cxlsx&
app=Excel&
...

**0**

votes

**1**answer

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

**2**

votes

**2**answers

28 views

### Best way to search for a string (text) in >10 large CSV files (250mb each)

I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size.
My idea was to write a powershell script, since I ...

**1**

vote

**1**answer

17 views

### Sorting and removing duplicates

I have the following table:
Column 1 | Column 2 | Column 3
1 | A | 70
2 | A | 32
3 | A | 4
4 | B | 44
5 | B ...

**0**

votes

**0**answers

17 views

### How to build a radar graph? [duplicate]

Does anyone know how to build a graph like this? Preferably in excel or using a simple online tool? There is similar on this web-site, but not exact. I need to have 4 sections, each containing 5-6 ...

**0**

votes

**0**answers

7 views

### Retain original Hyperlink format in Excel (from a hyperlink formula)

I extracted some data online. I wanted to format the hyperlinks as the original hyperlink format when you copy an anchored text online to sheet.
The content of the cells formula is shown as: ...

**0**

votes

**0**answers

3 views

### Google Sheets Suffix To Column Cells [closed]

I'm editing a spreadsheet of product data that has a category column. I'd like to create a new "Left Handed" as well as "Right Handed" category in addition to each products current categories.
I've ...

**0**

votes

**1**answer

9 views

### Open .csv file with template from XLSTART

I'm testing the program which would create a large .csv file and need to open it with minimum clicks (saving my hands) during testing. The file contains 20+ columns of counters, no formatting ...

**0**

votes

**1**answer

16 views

### Excel: INDEX and array on another sheet

My raw data is a list of students and their grades on Sheet 1.
6th Bobby
6th Carl
7th Tommy
8th Bobby
I want Sheet 2 to give me a list of students based on the grade I input into cell A1.
example: ...

**0**

votes

**1**answer

18 views

### Calculate Break Point Weight

I have a table like so:
Miles Weight Rate
50 1710 54
50 3417 44
50 7253 38
50 12025 36
50 16052 35
100 1716 55
100 3429 45
100 7269 39
100 12027 37
100 16055 36
Where ...

**0**

votes

**2**answers

37 views

### Conditional Matching Based on Datetime

I have a set of names and datetimes on two sheets. One sheet we'll call LargerSheet and the other we'll call Sheet1. On LargerSheet each name has multiple datetimes associated with it. On Sheet1 ...

**0**

votes

**0**answers

40 views

### Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following:
Sheet1
Fruit______ Orange_Apple_Banana
...

**0**

votes

**1**answer

14 views

### AVERAGEIF based on formatting

I am using Microsoft Excel 2010. I would like to do an AVERAGEIF, with the criteria based on formatting.
Ex: For cells, I choose A1-A3.
A1 is the percentage value 10%.
A2 is the number value 20.
...

**0**

votes

**1**answer

11 views

### Changing external workbook Links in Excel

I have a report spreadsheet that I use monthly. It uses data from multiple workbooks that are linked to it. To update the report every month, I copy the tab from the last month and update the links. I ...