Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
15 views

Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a Current ...
1
vote
2answers
37 views

Align Secondary Axis Origin with Primary

I am interested in aligning my secondary axis such that it lines up exactly with my primary axis. To be more clear, I want the origins to both line up at 0 at the same place, each preserving their ...
1
vote
0answers
33 views

Hyperlinks to web pages in my Excel workbook don't work now

Hyperlinks to web pages, saved in my Excel workbook don't work after upgrade to Windows 7 & new hard drive. Have had this spreadsheet for years. I was always able to click on the link and it ...
0
votes
0answers
37 views

How to reset my forgotten Excel worksheet protection password? [duplicate]

I was using my Excel Workbook for recording some of my important data on my password protected worksheet. But one day when I was attempting to open the workbook I just forgot the password how I can ...
0
votes
1answer
32 views

Excel, split cell after first space

Is possible to split cell after first space? ID;name;city street;phone; 51;Joe;Paris Sezame street;77755566; 52;John;Prague Under Bridge;666555444; 53;Helen;Tokio 3.st;66554455; Like ID;name;city; ...
0
votes
1answer
21 views

Excel, how to subtract time to span before midnight

I am trying to subtract hours to a time that is close to midnight, but excel is outputting all hash (#) symbols complaining of the operation. Adding time is easy and possible, as described by this ...
0
votes
0answers
12 views

Excel - Updating a .xlsb file when saving a .xlsx file

I work on Excel for Mac 2011. Sometimes, for no apparent reason, I can't open one file I saved in .xlsx. I did some research and found it was a bug. The only workaround I found is to save the file ...
0
votes
1answer
17 views

Tableau workbook [closed]

I'm new to Tableau, and I don't know how to add more than one dashboard in my visualization. How can I present all my visualizations and not dashboard by dashboard? I need help with this issue. ...
0
votes
1answer
21 views

How do I use custom formatting to change number from ########### to #####.##.##.## in Excel?

I have a very large list of numbers that range in size from 9-17 characters. I need to add periods to make them compatible with a specific program. Example: 1000409180201 --> 10004.09.18.02.01 Is ...
2
votes
1answer
41 views

How to Make a PivotTable out of “hierarchical” Excel spreadsheet data

I would like to create a PivotTable out of "hierarchical" data contained in an Excel 2010 worksheet. The data is hierarchical in the sense of a parent/child relationship in a database where, ...
2
votes
2answers
20 views

Same time value in two different cells, different decimal value, no match possible

I'm trying a index match function on two different cells in which is the time value 08:30:00. I never got a match and after long searching I found that there's a minuscule difference in value between ...
2
votes
1answer
35 views

Excel - sum values based on a column that match another column in another table

I've been working my head around this, but haven't figured it out yet, and I'm sure it's dead simple. Suppose the following example: There are two tables, one containing animals, and the other one ...
-1
votes
1answer
52 views

Excel Password Recovery [duplicate]

I have forgotten my Excel password the file was in Win 2003 version. I tried many tools for recovering back the password but none of them helped me. Please help me…
1
vote
1answer
23 views

How do I sort and merge data (in Excel) with hexadecimal codes?

I take attendance in large, lecture classes. Each student inputs a vote on a multiple-choice question with a "clicker" (a hand-held, remote control device), and each clicker has a 6-digit, ...
-4
votes
1answer
53 views

VBA for “IF formula” with multiple results in a single cell [on hold]

How can I convert this to VBA? Using this formula, it cover 6 rows only and the formula is already too long. My report has 600 rows. =IF(AND('Risk & Issue Log'!$K$2=$D5,'Risk & Issue ...
-2
votes
0answers
25 views

Windows 7 Pro, Office 2010, Excel bug in VLOOKUP and INDEX

These two lookup functions return a false 0 value when The cell being looked up exists but is EMPTY - i.e. if the cell is displayed in VBA, it is shown as "EMPTY", not blank or zero or a string ...
-1
votes
1answer
34 views

Excel function to return values in Array1 but not in Array2

Array1 = {1,2,3} Array2 = {3,4,5} What function will take these two arrays (as ranges on the worksheet) and return the values that appear in Array1 but not in Array2? In my example, the desired ...
0
votes
1answer
31 views

Data from different months into one chart, colored differently?

I have three sheets with pivot tables in one Excel document. These table different slightly from month to month: table 1 - Jan bike 100 scooter 20 table 2 - Feb bike 20 skateboard 2 ...
0
votes
1answer
43 views

Excel: How to clear all renamed PivotTable labels

When using PivotTables in Excel, it's often useful to overtype certain PivotTable labels with new names. If you have a long list of items you've relabelled, it can be easy to lose track of what the ...
0
votes
2answers
18 views

Cells apears blank but cannot be replaced

I try to replace blank cells by Ctrl+F function, however, there is one cell that cannot be replaced, although it appears empty. But when I use data filter, it is shown as "blanks". Could anyone ...
0
votes
2answers
31 views

MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified. So let's ...
0
votes
1answer
28 views

What function to use in Excel?

Working on an Excel project and can't figure out what forumula to use. Any help would be awesome! B39 has the transportation costs for 2013. C39-F39 have transportation costs for 2014-2017. C20-F20 ...
0
votes
0answers
20 views

Reduced Row Echelon Form in Excel

I was wondering if there was a way I could enter some matrix in excel like ... 1 -1 -1 0 15 5 0 -5 0 -5 10 8 With each number in a cell, and then have excel transform this matrix into reduced ...
0
votes
2answers
22 views

Referencing text from one cell into an equation in Excel

I have text in a cell (A1) that is also the name of a worksheet within my workbook. How do I go about referencing a specific cell on that sheet? I want it to look like the formula below without having ...
0
votes
1answer
22 views

How can I visualize resource demand in an Excel diagramm?

I have a table that contains a list of projects. Columns include project start date, and the efforts for different platforms needed for that project. So for example projects starts 1st of april, and ...
0
votes
1answer
25 views

Grab data in excel from an excel that will be downloaded tomorrow

I have set up a way to automatically download my Google webmaster tool data every day. Now, I have a main excel sheet which holds all that data, that I normally update manually. However, I'd like to ...
1
vote
1answer
39 views

Excel How to make Text Qualifier editable or add a new entry in the existing list?

I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote. Example: "col1","col2","col3" ...
0
votes
1answer
27 views

Nesting the IF Function in Excel when there may be #Value! errors in the target cell

I'm trying to get some help to change a formula: =IF(S4>8000,3,IF(S4>6000,2,IF(S4>4000,1,IF(S4<4000,0)))) So that it returns a value of 1.5 if the target cell contains an error value. ...
0
votes
1answer
14 views

Excel: Stop watch format without seconds

How to achieve a cell format like 26:30 (meaning 26 hours, 30 minutes), without seconds? Such format is not predefined. There is only 26:30:00 or 26:30,0 in the program settings available.
1
vote
2answers
32 views

MS Excel Column content replication across two sheets

Microsoft Excel functional Question How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in ...
1
vote
2answers
23 views

What's the best way to cut out all text before or after a matching string with excel or open office?

I have a column of naughty data, that needs to be standardized. Its a single column, so I'll just include a snippet of it it here: pop_density_2010 7002854600000000000854.6/sq mi (329.97/km2) ...
2
votes
1answer
26 views

Counting Text Cells

I need an efficient way to count the number of cells in a column containing text. The formula: =COUNTA(A:A) gives a result, but that result includes cells containing formulas returning "", which I ...
1
vote
1answer
26 views

How can I summarize cells based on date in other cell?

I have one Excel sheet with columns "project name", "project date", and "effort estimation". On a second sheet I want to summarize those projects according to the months of the year. So I have ...
0
votes
2answers
57 views

Can MS Excel use non-printable characters as field separators in CSV files? If so, how?

I've just discovered that many of the character encodings have non-printable characters designed to separate different pieces of information, e.g., ASCII character 31 is the "unit separator". It ...
1
vote
3answers
38 views

Excel combine rows dollar amount with matching row values?

I've ran into a problem with Excel, I have the below table Basically, I'm trying to figure out how to make all rows that have the same product key combine, except calculating the dollar amount for ...
-1
votes
1answer
38 views

Calculating Dates Backwards in Excel

I am trying to calculate 6 Fridays before a certain date, as well as 4 Fridays before a certain date, in order to establish deadlines for several departmental responsibilities. I would like the dates ...
0
votes
1answer
16 views

How do I copy data to another sheet over multiple columns?

I have a 2 sheet Excel book. The first sheet has a number of columns,filled with data including 2 columns with peoples names (surnames and Christian names). The second sheet has 6 columns in which I ...
0
votes
0answers
32 views

Conditioning Format

I have two worksheets in one workbook. I have two columns of numbers and texts in the first worksheet that I want to duplicate to the second worksheet if there is a dollar value in a cell on the ...
0
votes
3answers
40 views

How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...
0
votes
1answer
33 views

Using Dynamic Repeating Formulas in Excel Templates

I have an Excel merge template that compares Actions to Results. It is used by many different sales people. For that reason, the length of the spreadsheet can vary. The users have limited Excel ...
0
votes
3answers
37 views

In Excel replacing a column with another column

I have a list of Variables in Column A > list of items another list of variables in Column B > with corresponding Item Codes for >> column A And in Column C > I have list of item codes randomly ...
0
votes
2answers
15 views

Combine two excel documents with imported data and pivot tables

I have two excel documents. Each has a sheet with imported data from web and a sheet that contains a pivot table based on the imported data and chart summarizing that pivot table. I want to combine ...
0
votes
2answers
24 views

How to highlight strings that match pattern in Excel?

I have a large set of data that needs to have some visual formatting cues added for visual review. Essentially the particular matches are phone numbers that have to be matched and when found the row ...
1
vote
1answer
45 views

Excel - Lookup to match varying criteria

I have a list of poles, some with more than one test result. I want to find the latest test result for each pole and then return the result. As we know, VLOOKUP only finds the first. I don't want ...
0
votes
1answer
49 views

How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns). The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...
-2
votes
1answer
33 views

How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging: Date Running (minutes) Pushups Pullups Crunches and the rest of my workout entries. I insert my achievements each day. How can I script Excel to ...
0
votes
2answers
28 views

How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one. I was thinking I could create a button to copy the fields ...
0
votes
2answers
36 views

Formula update no longer working

I have the same formula update problem as others posted on this site. I have a formula =SUM(B1+B20). I'm trying to enter dollar amount in B1 and updating the dollar amount in B20, thus increasing ...
0
votes
1answer
17 views

Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...
0
votes
1answer
12 views

Fixing numeric cell in a formula in excel on a Mac

I would like to use repeat a formula with some constants noted in an assumption table how do I do so in Excel on a Mac. In Excel on a non Apple device the formula would be something like this ...