# Tagged Questions

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

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

**5**

votes

**4**answers

16k views

### How do I save an excel spreadsheet as a semi-colon separated values file?

I am running excel and would like to export my file as a .scsv (semi-colon separated values) sheet instead of a .csv. Is there any way to do this?
ps. I can't do a .csv and search and replace ...

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

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

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

**1**

vote

**2**answers

317 views

### Excel IF statement

I am trying to look at column E and if it is >0 put a 1 UNLESS column D has a value. If column D has a value, I would like to copy the contents of column D. I was thinking the following formula would ...

**4**

votes

**6**answers

12k views

### How can I make Excel documents open in different windows?

Office 2007, Windows Server 2008 x64.
How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows ...

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

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

**2**

votes

**3**answers

14k views

### Excel: Multiple =IF calculations within one cell

I need to do some text comparisons in excel, about 20-50 of them. I would like the result of these if statements to be within a single cell. Here is how I WISHED it would work:
...

**2**

votes

**1**answer

2k views

### Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet.
I just need it to separate the files based on a column into a separate ...

**1**

vote

**1**answer

649 views

### Excel graphs: MIN/MAX axis scaling isn't working correctly

I have lots of graphs which I need to compare against each other. Therefore, I need a common scaling along the vertical (Y) axis. I'm encountering problems when pasting in my MIN/MAX series, and then ...

**0**

votes

**1**answer

419 views

### filter through one excel spreadsheet using data from another

I have 2 excel files. One holds some products that i need to put into a database but it doesnt have all of the information i need.
The second file has all the information for these products but there ...

**1**

vote

**1**answer

2k views

### How to apply a 'comma separated list' as a filter in Excel?

I have a stock-list of books and would like to filter the stock data only with selected publishers.
Is there a way I can provide a 'comma separated list' in the filter?
I tried the 'Advanced ...

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

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

**1**

vote

**2**answers

159 views

### Working with “~” in excel

I have a data set that has names that contain ~ within them. Unfortunately, I cannot find a way to filter or incorporate these cells in a formula.
For example, I tried to use a text cell that had ~ ...

**2**

votes

**1**answer

2k views

### Excel graphs: How do I apply a graph template format?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...

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

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

**0**

votes

**1**answer

3k views

### Plotting quarterly and monthly data in Excel

I have one monthly data series in one spreadsheet and one quarterly in a different spreadsheet. What is the "smartest" way to plot them together in one graph (in Excel)? Its quite a lot of data, so I ...

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

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

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

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

4k views

### Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive.
I have an Excel workbook which contains around 50 columns
I have a criteria column for splitting this workbook into mulitple workbooks
The approach is as ...

**0**

votes

**1**answer

2k views

### Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule

**1**

vote

**1**answer

219 views

### Excel for Mac: Convert Windows split to txt macro

I'm a total VB hack - as in cut/copy/paste and try to make things work. The code below worked on my Windows machine, but won't work on my Mac.
I get a file/path access error on this line:
Open ...

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

**2**

votes

**3**answers

12k views

### How to count number of repeat occurrences

I have an Excel Spreadsheet that looks more or less like this:
+------------+-----------+
| First Name | Last Name |
+------------+-----------+
| John | Paul |
| Joe | Jones |
| ...

**2**

votes

**2**answers

1k views

### How to filter for every 4th row in Excel?

I have an Excel file (xlsx - MS Office 2010) that has a column (Just A) and 3000 rows.
I want to filter for every 4th row.
for example:
TEMP -- 1
TEMP -- 2
TEMP -- 3
TEMP -- 4
TEMP -- 5
TEMP -- 6
...

**1**

vote

**3**answers

6k views

### Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)

SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...

**1**

vote

**2**answers

1k views

### How can I filter specific rows from an Excel spreadsheet based on criteria?

I have a spreadsheet from which I need to select ONLY the first five rows in each category.
I only want columns A and B when C is less than 5 -- =IF($C1>5,$A1,) and =IF($C1>5,$B1,) -- but I ...

**4**

votes

**1**answer

475 views

### Filter comma-delimited Excel column

I have an Excel sheet serving as a master spell list for a tabletop game. Each row (save for row 1) contains the data for a spell: Name, Target, Range, Duration, Function, Effect, Subject, Level, and ...

**0**

votes

**1**answer

228 views

### Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries.
I do not want to simply remove ...

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

**1**answer

18 views

### One dimensional charts in excel

I have 5 measurements (series) of six values going from 1 to 6.
So,
Series 1: 1.3;2.5;3.2;3.3;3.9;5
Series 2: 1.1;2.8;3.1;4.4;4.9;5.1
...
I would like to create a scatter chart where Y-axis would ...

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

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

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

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

**0**

votes

**2**answers

168 views

### How to merge rows with same Name merging data of each ?related column

I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows ...

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

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

**1**

vote

**3**answers

30k views

### Automatically update cell in Excel with current timestamp when another cell is changed

In an Excel spreadsheet, I'd like to automatically update a cell with the current date and time when another cell is changed (like an update timestamp).
There is a timestamp for each row. I'd like to ...

**4**

votes

**2**answers

5k views

### How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force ...