**0**

votes

**2**answers

29 views

### Excel: check if two cells have specific content and show true/false in another

I have a large datasheet with multiple columns. Long story short, my columns A and B (of text type) are lists of codes. For simplicity's sake let's say column A is days of the week, while column B is ...

**0**

votes

**1**answer

42 views

### Excel Convert Row into Multiple Columns

I have a very long list of data that looks like this:
User1 Item1 Item2 Item3
User2 Item1 Item2 #NUM! (This is a failed formula)
User3 Item1 #NUM! #NUM!
And I want to ...

**-1**

votes

**0**answers

20 views

### Get name from several sheets and put in this name in another sheet based on value in a column

I have in sheet Huvudlager and a column named Namn in H2 there are no values in this colomn. But I also have sheet named Låda1, Låda2, Låda3 and in these sheets I have columns in A2 Serial number and ...

**1**

vote

**2**answers

60 views

### Excel: using 2 cells to collect data from a list

My Example is this:
(workbook name"Rev)
letter weekly bi-weekly monthly
a 100 200 400
b 110 250 500
c 111 300 600
d 112 350 700
e ...

**0**

votes

**0**answers

21 views

### Matching words from two title and calculate %

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B and calculate the % by using the "no of words matched/total no of words ...

**56**

votes

**2**answers

3k views

### Excel - can I set a cell to equal a certain value, no matter what is typed in it?

This is to play a joke on someone...not sure if it's possible to do what I want. We are circulating an Excel file among friends to select players for a golf tournament. I would like to set a cell ...

**-3**

votes

**0**answers

15 views

### Copying and pasting cell links from various workbooks

There are 99 folders named CAL1, CAL2, etc until CAL99 . In each of the folders there is workbook named "RESULTS". The full path is as followes:-C:\NEW CALCULATIONS\FIRST\CAL1\RESULTS.xlsx, C:\NEW ...

**1**

vote

**1**answer

31 views

### Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C

So basically I have a worksheet like so,
The data is manually entered in, column A is the date, the values are column E. Everything else is arbitrary and filled with x's. Basically what I want to ...

**0**

votes

**1**answer

50 views

### How can I convert colums to rows in Excel? [duplicate]

Below is a sample of a spreadsheet I have (fig 1). It has been exported from an asset tracking system and provides me a list of information about the hardware we have.
Each asset "area" uses the same ...

**0**

votes

**1**answer

22 views

### IF X and A display area “A1,G20” If X and B display area “A1,G20” but on a different sheet

I'm trying to put together a excel spread sheet for our quarries.
but we have a lot of different pits along two rivers that we collect our raw material from each with its own set of sieve results. now ...

**0**

votes

**1**answer

28 views

### How to modify these VBA codes to save excel sheet in excel format (.xlsx)?

I have added a button in excel sheet and now when I click that button it saves the sheet at specific path with specific name but in pdf format.
I want to save this sheet simply in excel format ...

**-2**

votes

**1**answer

37 views

### How do I add a button to a spreadsheet and remove borders from a particular cell?

I have two queries regarding the following Excel file:
I would like a button on this excel sheet whose name should be “Save as PDF”.
When I press this button it should save the excel sheet’s ...

**2**

votes

**0**answers

27 views

### Excel 2007 on Win 7 Home Edition — failure to sum numbers when pasted from other source

I copied/pasted columns of numbers from my bank statements into Excel. When I try to sum groups of numbers, it does not sum them. Matter of fact, when I select a group of cells with numbers, it does ...

**1**

vote

**1**answer

43 views

### Highlight Cells with Red Text

I have a column of text in which some characters (not cells) are in red font. Is there any way to highlight the cells which contain red characters via conditional formatting? VBA solutions would be ...

**0**

votes

**0**answers

46 views

### Conditional formulas in Microsoft Excel

I have different conditions in a sheet where I need to update certain factors like term of loans and down payments. How do I apply a formula in excel where I can get direct result for these:
Down ...

**1**

vote

**1**answer

34 views

### Excel - group cells that the values together is near to a number

I have this spreadsheet:
Street 1 | 234m
street 2 | 438m
Street 3 | 759m
Street 4 | 934m
Street 6 | 126m
Street 7 | 462m
These values are summed and divided by 2 in this example, because let's say ...

**0**

votes

**2**answers

44 views

### Segregating title into words and searching it in a another title

I was trying to automate an Excel file which has title in both A and B columns and I have to search each word from A within B. If any words matches then I need to paste it after B column which is ...

**0**

votes

**0**answers

13 views

### Excel spreadsheet calculation does not happen

Excel spreadsheet calculates fine when entering a value, but then to change that value back, the calculate option appears in bottom line. Why?

**0**

votes

**2**answers

39 views

### How to compare time in multiple rows using excel 2007

I need help to compare time in multiple rows in excel. I am creating a new rule in conditional formatting. I'm entering this formula in formula bar to compare time across multiple rows:
=IF($E$4:$E$6 ...

**1**

vote

**1**answer

22 views

### Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...

**1**

vote

**2**answers

35 views

### Extract string containing a word from an Excel cell with hundred of strings

I have an Excel workbook, in column A each cell contains all URLs of a site (this means hundreds of URLs in one cell).
Among all the URLs within a single cell I want to extract only the URL that ...

**0**

votes

**0**answers

14 views

### Realtime update of Powerpoint data from excel (no graph)

I am trying to create a PowerPoint to be used for a non-profit gala pledge drive. I want to show the names of folks pledging and the amount. Plus, the running total of amount pledged.
I was planning ...

**2**

votes

**1**answer

44 views

### On Excel I want to create a list from another sheet based on two values

I have 2 values in dropdown menus in cells B2(DATE) and B5(ITEM).
from these values I want to create a list of items(based on B5) that were sold on that date(B2).
The transactions are listed on a ...

**0**

votes

**0**answers

7 views

### Excel is removing embedded images within by 2007 files. How to I prevent this?

I have embedded Jpg images into a column within an excel 2007 worksheet. However when I try to reopen the file, excel says it can not read the data in this Column and then strips it out. How do I ...

**1**

vote

**2**answers

68 views

### How do I create randomized word lists that are dependent on a master list?

I am using excel for Mac 2011
For a linguistics project I want to do the following. I will have a word-list like this (in reality it will be much bigger):
Master List:
Bag
Leg
Magnet
Apple
Gum
...

**0**

votes

**0**answers

10 views

### MS Excel 2007 report made using Excel is slowing down day by day

I have an Excel file on a shared folder in use daily, perhaps 5-10 times per day. Editing it less than 5 times a day. My assistant doing same.
The size of that file (empty) is less than 600 KB. Also ...

**0**

votes

**1**answer

16 views

### Taking data from an adjacent cell by name in cell

I am a basic Excel user.
I do a monthly rota which has the staff name in one cell and in the following cell it has the hours worked.
Is there a simple way to write an formula so that Excel takes any ...

**0**

votes

**1**answer

29 views

### VBA Script loops in all sheets but doesn't produce output in all sheets

This VBA script I have loops through all sheets but I don't see the output in all sheets. What would be the reason be?
Sub A()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Dim ct As ...

**0**

votes

**1**answer

27 views

### How can I apply this macro to all the pages in an excel file

I have a code to do a particular modification to some cells in a page. I'd like to apply this code at one click to all the pages in the excel file. I'm using VBA and am a newbie to it. Here's my code ...

**2**

votes

**1**answer

44 views

### How can I execute this function using VBA in excel?

I'm trying to get this function in VBA but I'm new to it. I don't seem to know how I can get this done:
What I'm trying to do is, for each cell in column B that's numeric, I want to take the next ...

**0**

votes

**1**answer

13 views

### How to fill missing times with dummy values?

I have quite an urgent question. I have data (concentration) which was logged every minute. However, when I download my data there are some times (e.g. 1 or 2 minutes) in between missing.
For 24h I ...

**0**

votes

**1**answer

35 views

### How to copy a formula or value into another formula

I want to know how to copy a formula into another, while keeping the original values. For instance, I have in range A1:A5 five values (a mix of constants and/or formulas) and I need (in that same ...

**-2**

votes

**0**answers

33 views

### I need to compare name and amounts in 2 excel spreadsheets, what is the best way?

I have 2 excel spreadsheets.
Spreadsheet one - I need compare these 2 columns;
Name Amount
Mr Test £10.00
Spreadsheet 2 - I have created a pivot table and it shows the following;
Name ...

**-1**

votes

**1**answer

24 views

### How to expand a range of values to individual values separated by commas in MS Excel 2007 and 2010

How to expand a range of values to individual values separated by commas?
Example 1:
convert R1-R8 TO R1, R2, R3, R4, R5, R6, R7, R8
1-10 TO 1, 2, 4, 5, 6, 7, 8, 9, 10
I need these expanded range ...

**0**

votes

**2**answers

67 views

### Reset Sequence Number With Change of Month

(Cell A1) Invoice Reference No. EPS-I-S151001
(Cell B1) Invoice Date 05/Oct/15
Once the Invoice Date is manually entered, Invoice Reference No will be automatically generated.
The ...

**0**

votes

**0**answers

32 views

### Can Excel auto generate squencial number?

I have a manual invoice registry log which I would like to overhaul.
Currently I will manual assign an invoice number when I want to create a new invoice. Let's say Column A is the Invoice Number and ...

**1**

vote

**0**answers

27 views

### Excel gives error while opening file recovered from a corrupted drive [duplicate]

I accidentally deleted my data on my drive which also got corrupted when I tried to recover the data. I got my Excel files back but they are not opening. Excel is giving errors that it is damaged or ...

**0**

votes

**0**answers

30 views

### Populate information from on spreadsheet to another on same excel File

I am creating two sheets for one excel file for business conferences . One sheet will be an inventory list of items being sent to conferences, the other a sheet that contains details of the ...

**1**

vote

**1**answer

45 views

### Performance Gain From Excel 2007 to 2010/2013 for modern PC

My work recently upgraded my department’s computers to shiny new spiffy i7 ssd 16GB RAM boxes. I spend most of my time in excel/access and the company still uses the 2007 versions of this software. ...

**0**

votes

**1**answer

31 views

### How do I get the cells with no dates to have no color until the date is entered? All of the unused cells are red

=DATEDIF(F2,TODAY(),"m")<=47 THE CELL TURNS NO COLOR
=DATEDIF(F2,TODAY(),"m")>57 THE CELL TURNS RED
=DATEDIF(F2,TODAY(),"m")>54 THE CELL TURNS PINK WITH RED WRITING
...

**2**

votes

**1**answer

95 views

### Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...

**0**

votes

**1**answer

13 views

### Nested Ifs for personal accounting sheet

I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour.
If C5 and D5 are both blank, ...

**0**

votes

**1**answer

33 views

### Special format of date in excel

A customer wants a special format of a date column in excel.
What he wants is that the date (for example 02.06.2014 and formatted as short-date) changes to a number (41792) when the format changes to ...

**1**

vote

**3**answers

40 views

### How to find average of first difference in one set of column excel/google docs?

I have one column with numbers eg. 130, 131, 135, 140, 120.., I would like to find the differences eg. 131-130, 135-131, 140-135.. and find their average without using another column to find the ...

**2**

votes

**1**answer

30 views

### Excel - split view of sheet horizontally but viewing two separated sets of columns instead of rows

I have a sheet in excel 2007 which is quite long horizontally. I'd like to see the 'first' columns of the sheet at the same time as the 'last' columns. If I split the sheet horizontally (with a top ...

**0**

votes

**1**answer

32 views

### Autofill formula to return data from every tenth row

In Excel 2007, how do I autofill a function of =OFFSET(C2,10,0) to end up as:
=OFFSET(C2,10,0)
=OFFSET(C12,10,0)
=OFFSET(C22,10,0)
etc.
as a pattern of referencing every 10th cell in the same row.
...

**0**

votes

**0**answers

30 views

### Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules:
=$B97=1 Set Format (Custom) ">" @ On cell =$D97
=$B97=2 Set Format (Custom) "> >" @ On cell =$D97
=$B97=3 ...

**0**

votes

**0**answers

36 views

### Exteremly Slow Microsoft Excel operation in LENOVO G550 series Laptop; Shall I add more RAM?

I am doing complex Macro operations in Excel 2007/2013 which generates random numbers and does many multiplications/divisions in each cell value. It also copies data to multiple worksheets and text ...

**0**

votes

**1**answer

25 views

### Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected.
Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...

**0**

votes

**1**answer

40 views

### Group values in Excel

I have 500 rows of items. I need to enter these in an application where I can enter a maximum of six items at once by creating a unique Group ID for these six items.
The items in a group share the ...