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.
1
vote
2answers
119 views
Passing Range to ABS function in VBA
I would like to perform a function which looks like this
Selection.FormulaArray = "=GEOMEAN(ABS((C646:E646)))"
Since my range keeps varying I would like to pass the range as a variable which looks ...
1
vote
0answers
27 views
Pull Data From Web Database With Excel 2007
I have a web based database that I work with regularly that uses 802.1x authentication (Smart Card with password). From the website you can pull premade and custom reports that are ultimately stored ...
0
votes
0answers
29 views
How to autofit data in drill down from spreadsheet
I have a pivot table and when I double click in it the resulting Drill Down Sheet shows with all the column widths as 8.43. I don't want the user to have to reformat the page but can't find a way to ...
1
vote
1answer
31 views
Excel formula PERCENTILE and how it works with ranges i.e A:A
Say I have the Excel formula PERCENTILE(A:A,0.01). I imagine that this range equals A1:A65536 (or whatever is max). But would that mean that in its calculation of percentile it has a list of 65536 ...
0
votes
2answers
49 views
Handling Excel historical data and formulas
I have a large amount of data in an excel sheet, which users type in directly, adding new lines with new data. Each new line of data represents a customer. Each customer will has a cell with: county, ...
0
votes
1answer
33 views
How does excel manage to correctly decode this file contents?
I start with an excel file with the contents in each row:
TEST
çığ
öğö
çüş
Then I export this file as a CSV file and save it as ANSI format (which from what I have read is same as US-ASCII). When I ...
0
votes
3answers
192 views
Is it possible to save conditional formatting rules for reuse in a new workbook?
I want to make some rules that I can haves saved that I can easily apply to new workbooks as needed. It's a pain doing it how I currently do where I'm always having to go back through and recreate ...
0
votes
0answers
50 views
Find out which cells got updated in Excel [closed]
I have an Excel spreadsheet that calculates some relative dates. At one point I put in some TODAY() formulae in various cells to update the dates automatically. Some other cells that refer to this ...
2
votes
1answer
119 views
Excel graph with 3 variables in 2D
We've conducted a hydrogen peroxide experiment (conversion to water and oxygen) under the effect of catalase in 5 different pH levels. We noted the volume of the formed oxygen after 30 seconds and 60 ...
0
votes
0answers
22 views
how to trace cell source in other sheet in excel 2003?
When I view this tutorial page, I found the following:
Use Trace Precedents
Choose a formula and click Trace Precedents. It is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing ...
0
votes
1answer
69 views
Vlookup not working as expected for soccer data
i have a vlookup function that is supposed to give me some data from another worksheet. the worksheet contains soccer data, specifically about the european cups of the past 3 years (9-10, 10-11,11-12, ...
0
votes
2answers
87 views
Batch filling pdf form using data from Excel
I have an excel file which contains many rows of data, each row has columns like last name, first name, gender etc. I would like to batch fill these data into a form which is in PDF format, each row ...
1
vote
2answers
56 views
IF command query
I'm trying to calculate different percentages for the same cell. Let's say for arguments sake it's cell A1:
If A1 < 50000 then multiply by 10%
If A1 > 50000 then multiply by 12.5%
If A1 ...
1
vote
1answer
50 views
Hide “inconsistent formula” error in a selection in Excel
This may seem easy to more advanced users, but I can't seem to find this out there.
I have a complex Excel worksheet. It has various formulas/calculations throughout the sheet.
Unfortunately, ...
0
votes
1answer
35 views
Keep data in first downloaded XLS from second sheet
I download data from a source with my software and store it in an .xls sheet. Such downloads are performed on regular bases and always stored in a new .xls sheet. The data looks like this:
Shri Ram ...
0
votes
1answer
67 views
How can I sort a list of numbers, by its last 3 digits in Excel
I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...).
Each one of the nubers if have 8-9 digits and I would like to sort this column by its ...
0
votes
0answers
75 views
Excel Radar chart to visualize data
I have a set of data with which I want to produce a Radar chart for easy comparison.
This is just like an inventory list with A,B and C as the products list, I want to achieve the following :
...
1
vote
1answer
56 views
Delimited string to rows in Microsoft Excel
I am looking to see if I can solve this problem using Excel- if not, I can write a script that would help me do this instead but it would be a little more time consuming.
Here is my data set:
This ...
0
votes
1answer
45 views
How do I get a formula result from one cell, reflecting in a sentence in another cell?
In Microsof Excel: How do I get the result of a formula, to reflect in a sentence? For example: I have a calculation in cell A1. Now in A2, I have the following sentence: "The result is.... and is ...
0
votes
2answers
30 views
Time Difference In Formatted Text
How can i find the time difference from like "9-10:30" formatted cell.What is the formula to find the "1.5" hour or "90" minutes from that cell.
0
votes
2answers
41 views
How to disable “This workbook contains macros”
This prompt comes up each time I open a file which I trust, is there a way to disable it permanently?
0
votes
2answers
63 views
Conditional count
I have 500 numbers stored in column A.
Which formula should I use to count the number of those that satisfy the condition 6<X<8? (I'm new to Excel so please give me instructions in detail.)
1
vote
1answer
35 views
Re-using conditional formatting in MS Office (Word/Excel)
I very often find myself with a formatting that I want to apply to several specific but isolated parts of a document or worksheet, without disturbing the format of the surrounding areas.
The ideal ...
1
vote
1answer
70 views
Dynamically insert value into cell
If TL;DR - Just go down to the EDIT...
I have a spreadsheet with a table - the table is a comparison of two different (but similar) sets of data. So basically 3 columns with the 3rd being the result ...
1
vote
2answers
32 views
Updating cell using input
On one of my reports, I have to enter in several order numbers. The order numbers all start with the same thing, but end in different numbers. example: "XXX-XXXXX-12345-..." where the "..." ...
0
votes
1answer
105 views
Why can't Excel open a file when run from task scheduler?
I wrote a powershell script that opens an excel workbook and runs a macro. When I run that script from PS console, or even from command line using powershell.exe script.ps1, it jus works. When I set ...
0
votes
2answers
69 views
Can't save Excel VBA as xla
I have my VBA code ready to have others test, and i was going to give it to them as an Add-in (.xla). I had tested this with some other code, to make sure i could do it, and was able to create an .xla ...
0
votes
0answers
37 views
Excel import data from web - change browser?
I am working on an internal web application, where some tables previously has been imported to Excel 2010 using the "From web" function under the "Data"-tab. Recently we upated this web-application to ...
1
vote
1answer
32 views
Just get date stamp once in excel
To datestamp a cell in Excel I use the forumula : =NOW()
The problem is that as I datestamp new cells all other cells which contain the formula NOW() are updated with the new datestamp. Is there a ...
0
votes
2answers
67 views
How to count number of rows excluding rows with duplicate data
I have a table in which the column "Doc. No." has duplicate info as below; please advise on which formula I should use to count the number of unique Doc. that I have (as reference to the below table ...
0
votes
2answers
31 views
Change cell shade when original value is altered
I want to create a shared Excel document (2010) whereby I create a document with data, send it around to colluegues and if they change a cell, that cell will change shade. The idea here is the ...
0
votes
1answer
43 views
Formating my Excel Cell Formulas
What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.
0
votes
1answer
40 views
Excel gives error whenever I paste a code with “,”
My excel is refusing every code that I paste that has "," (comma) (like to separate arguments). What could be the cause, could it be because my PC region is Brazil and excel is in english? It seems to ...
-1
votes
2answers
42 views
How to automatically use alternated 2 colors in excel rows?
I would like that excel automatically paint in an alternated patern the lines/rows, like this image (zebra like effect):
is it possible?
0
votes
2answers
42 views
Excel for Mac - chart with no interpolation of discontinuities?
I would like to draw a chart in Excel for Mac with no interpolation on discontinuities, like this:
How can I do that?
1
vote
1answer
53 views
Referencing the sheet name is not working [duplicate]
I'm trying to get the sheet name into a cell. I've tried using:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
but my Excel 2003 displays an error when I try to enter the formula. ...
0
votes
0answers
26 views
How to open a new worksheet with formating already done?
How can I add new worksheets to my table with some values and formatting already present? What I have been doing is duplicating an existing worksheet and then manually deleting the values. It's a ...
-1
votes
3answers
69 views
How to lock a formula with self reference?
I'm trying this:
C9 formula: =-40+C9
What I want to is being able to enter some value in C9 that will not overwrite the formula and get a result in that cell. For example:
If I enter the value 140 ...
-1
votes
1answer
267 views
How to save the Excel sheet without formula and macros?
We have an Excel sheet with some formula and macros. We want to save the data as an another Excel sheet without formula and macros before we run macros on the current sheet.
It should just save the ...
2
votes
2answers
74 views
Why is this simple Excel calculation not netting Zero?
It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.
Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx
1
vote
1answer
93 views
How can I set a keyboard shortcut to switch between Excel tabs?
I find the Ctrl+ PgDn/PgUpnot good enough. When I have a lot of tabs it's very annoying to get to the right tab, or move it and change the order, which is sometimes important.
I need Excel to switch ...
-2
votes
1answer
49 views
Conditional date formatting
The following needs to happen:
Enter a goal date in cell C1 and enter actual completion date in D1 when project complete
D1 will remain blank until project is complete.
If D1 is blank:
STATE 1 -- ...
1
vote
1answer
58 views
Inserting rows from an Excel spreadsheet as paragraphs in a Word document
I am trying to put the results of a questionnaire in a Word document.
The questionnaire is completed using a web application, and the results are stored in a database. The letter needs to only ...
0
votes
2answers
36 views
Need help creating macro in excel rows to columns
I have a data dump in Excel that consists of customer_id data with multiple equipment listed against the same customer.
Data looks like this;
customer_id equipment
1 xx
1 ...
0
votes
0answers
30 views
Excel doesn't use the tab-character in a txt-file
When I drag txt-files with strings and \t characters into my excel-sheet, excel can't handle the \t. Instead I have to type the tab-button in the txt-file. Why \t doesn't work?
-4
votes
4answers
81 views
Finding values that only appear once in column
I have 4 columns and ~10K rows. I wonder whether it is possible to extract the rows where the value in column (A in my case) occurs only once.
I don't want to filter out the duplicates, just the ...
0
votes
0answers
60 views
Finding duplicate rows in excel gets partial matches, need only full matches
I'm using Excel 2011 for mac, trying to highlight rows that are full duplicates. Using the conditional formatting options is highlighting partial matches, I only want it to highlight the row if all ...
0
votes
1answer
86 views
How to avoid Excel 2010 cell #reference error?
I've made an excel workbook which has 3 sheets.
One sheet for entering data in rows, with columns such as: Name, state, join date, days used on training etc.
Another sheet that takes input in ...
-1
votes
2answers
53 views
excel data validation in cells wit
In excel I was wondering how you go about adding a simple list (data validation) to a range of cells but have the data validation list only appear if the adjacent cell is filled? For example a simple ...
0
votes
2answers
82 views
How can I refer to a cell that is a constant number of cells away from a particular cell?
I have two identical tables on a sheet: one that contains text for reference, and a second that contains values.
I am trying to sum up some cells in the second table but using the addresses of ...
