# Tagged Questions

**-2**

votes

**0**answers

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

**0**

votes

**1**answer

9 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

9 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

12 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

16 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

8 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

**0**answers

22 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

23 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

18 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

10 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

20 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

31 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

10 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

25 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

15 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

23 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

21 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

13 views

### Decoupling Pivot Table Groupings

Is there an option anywhere in Excel that I'm missing that allows you to decouple two pivot tables? The default option is to change groupings of a particular variable to be the same throughout all ...

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

38 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

26 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

16 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

20 views

### Excel is automatically joining two or more columns into one

I am having a very weird problem in Excel 2013. For example, lets say i have a worksheet with these values in 3 :
A | B | C |
1 TEST | Col | newCol |
2 TEST2 | Col | newCol |
3 TEST3 | ...

**0**

votes

**0**answers

3 views

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

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

8 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

15 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

17 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

33 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

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

**0**

votes

**2**answers

25 views

### Excel COUNTIF range search returning #N/A

I'm using Excel to search multiple days (my ranges) in a timesheet for hours worked (my HLOOKUP reads the value below the dept number) by multiple members of staff for different departments.
I've ...

**0**

votes

**0**answers

6 views

### Grouping and Nesting don't work

I have downloaded the example for grouping and nesting for ExcelWriter 7.6. But on my system the tags %%group, %%endgroup and also the cell &&value(...) will not be substituted by data. All ...

**0**

votes

**2**answers

16 views

### Excel - formula to calculate average for variable number of rows in table?

I have a table where the value in column B is the average of some preceding values in column A.
I want to use a named range "DaysToCount" to vary the number of rows used for the average. I've tried ...

**0**

votes

**1**answer

11 views

### Keyboard Shortcut to Run Macro in Excel for Mac

Basically the title says it all. In the editor in Excel on Windows, all you have to do to run a macro is press F5. What is the keyboard shortcut to do this on a Mac?

**0**

votes

**1**answer

19 views

### Make excel assume that I want to open my xlstart file readonly

I have a workbook called Book1.xlsx in my XLSTART folder. Is there a way to tell excel that I want it to always open this file as readonly unless I specify otherwise? There are two reasons I want ...

**0**

votes

**3**answers

15 views

### Excel - How to merge rows from 2 tables based on a common column?

I am trying to merge 2 worksheets where only one col matches in content.
Column"A" in both worksheets have matching values but all other fields are different.
Worksheet1
Col"A" colb colc cold
...

**1**

vote

**3**answers

24 views

### Excel format cell with its value over another cell's value

I have a number in A1 (let's say it is 10). This represents the number of answers in a test.
In B1 I have the number of correct answers from the test (let's say this number is 6).
In B1 I want to be ...

**0**

votes

**0**answers

32 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

**1**answer

28 views

### Get row number for the row matching multiple criteria in Excel

I have 2 worksheet that work together. Worksheet "Application" has a DATE column, a CODE column (a single digit number), and a VALUE column with a dollar value.
Worksheet "Scheduled" also has a ...

**1**

vote

**1**answer

21 views

### excel link to another sheet in same document without using filename?

This formula does exactly what I want:
=HYPERLINK("[!Monitoring Profile Matrix v2 (In Progress).xlsx]Metrics!3:3", "POWR01")
However, if I rename the document, I'm assuming all my links will break. ...

**0**

votes

**2**answers

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