0
votes
0answers
24 views

Plot 3 y axis in excel

I'm trying to plot three axes on the same graph. My data headings are: date/time (x axis), water level, temp, trout up, trout down. I've seen examples where this is possible but don't know how to do ...
0
votes
1answer
11 views

I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs) On the same Sheet I want to ...
1
vote
1answer
38 views

VBA change Script on multiple tables

Via this forum I found a way to refresh autofilters in a table automatically after the data in a excel worksheet has changed, using this VBA script: Private Sub Worksheet_Change(ByVal Target As ...
0
votes
2answers
915 views

Excel: DD/MM/YYYY stored as text…need to convert to Date format

I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY ...
0
votes
1answer
33 views

Transpose data by checking similar cell data

I have a Excel sheet like below.. Color Size Qty Red L 182 Red M 223 Red S 155 Red XS 30 Blue L 700 Blue M 845 Blue S 665 Blue ...
-1
votes
1answer
668 views

How do I remove multiple page breaks between rows in excel 2010?

Multiple page breaks appeared between each row and column on an excel 2010 spreadsheet. How can they be removed?
1
vote
0answers
47 views

Excel opens previous revision of file for a specific user

I have a user that opens an Excel file on the network and gets an older revision of the file. Everone else can open the file fine. this user received a new computer and new version of Excel (2010) ...
1
vote
1answer
67 views

Excel_macro_pivot table_analyzing data

I have two problems with my data in Excel. I have this table, so for every day in the year I have got 24 values, that´s 365 columns. I need to write a macro, that transform the data vertically, ...
0
votes
3answers
4k views

Microsoft Excel Formula - Highlight a cell based on text input in another

I have a table with a column B6 - B24. This contains company names. Another column G6 - G24 with notes. I would like a formula that would highlight a company name(column B) if the text "call off" ...
0
votes
1answer
69 views

I want to calculate difference between higher date and lower date in excel where the dates are in two different rows having one common factor

Example: Row A Row B Col A: - AMS Alert 1-sep12 1-sep12 Col B: - AMS Alert 4-sep12 4-sep12 Now I want to calculate turn around time for task AMS Alert where I ...
1
vote
3answers
2k views

How do I prefix a text to an Excel column? - all numbers are in rows

For example, if the number is 123456, I want it to become RNE123456.
1
vote
2answers
1k views

How to report an excel bug to microsoft [closed]

Can some one give me a direct link to submit a bug on MS Excel 2010?