A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

1
vote
2answers
29 views

Export whole excel sheet with chart to png

Say if you got a fancy excel sheet with chart and numbers, is there a way to export what you see into a PNG or some image file? I tried something: 1 Excel=>PDF=>PNG: doesn't work; crop by page (I ...
0
votes
1answer
36 views

Look up name in a table and retrieve the score from 7 columns down based on the latest location that name was found

Here is an image of the sheet I am working on For column T2:T I am trying to create a formula that searches table 1 A1:O for the last game the player has played and retrieve their score, which ...
0
votes
0answers
19 views

Is there a constant to represent “last row of a column” in Google spread sheet? [migrated]

I have a function like this in Google spread sheet: SUM(A10:A500) I'm using 500, but if it's possible I want to use a constant that represents end of the column A (i.e. the last row of a column ...
0
votes
0answers
26 views

“Random” Number Generator Based on Pattern?

I'm very new to Excel but I've been using it to generate numbers, based on data I already have. The thing is I don't need "completely random" numbers. I'll have the first row randomized using the IF(...
2
votes
1answer
51 views

Google Sheets to Excel

I have this array formula. =ArrayFormula(IF(P3:P="",,IFERROR(VLOOKUP(P3:P,sort({{C:C,L:L,A:A};{D:D,M:M,A:A}},3,0),2,0),UPLUS(V3:V)))) It works fine in google sheets. But when I converted my google ...
0
votes
1answer
25 views

Excel custom function | formatting

I'd like to get the SUM of cells with a specific format in the same format. For example, I have a column of column of cells with: 23/02/11 00/01/02 05/12/06 28/15/19 < I want the total to be ...
0
votes
1answer
17 views

nhow to find latest day of entry into a row?

I have an excel sheet to track daily activity, were in I used to update whether I have completed thta activity in a particular day. Other days remained blank, if activity not done. Suppose I have in ...
0
votes
1answer
51 views

Excel Transposing Every nth row to every nth column

Been trying to figure this out for a while and every solution I've tried hasn't been terribly successful for what I'm trying. Basically what I'm trying to do is take every other row in a spreadsheet ...
0
votes
0answers
8 views

VBA Excel (2003) Macro to sequentially Open Workbooks, run Auto_Open in each, and Close

Code for stepping and looping through related workbooks (all macros in opened workbooks identical). This code is in a separate file/workbook from those opened in the this code. Public Sub ...
0
votes
0answers
26 views

Excel If() function not working properly

I'm trying to set up a royalty payment that is the greater of $2000 or 30% of net revenue and the formula checks out, but does not render the correct value of $2,000 when the condition is met. Rather,...
0
votes
2answers
24 views

Is there a more elegant IF solution than nesting duplicate formulas?

Currently, I regularly write index match formulas that, if they pull an empty cell, pull a zero value. I then need to remove this from my results. I don't want to faff about with Find and Replace, and ...
0
votes
1answer
25 views

Excel, Way to check if spreadsheets are identical?

I have 2 spreadsheets I want to get in sync. Is there a way to compare other then eye-test ? They are complex format with same formatting to cells. They are close I just want to confirm they are ...
0
votes
0answers
13 views

Relocation of values with an empty cell beetwen them

I need some help with an excel formula for a specific task. I have a raw excel sheet imported from Autocad. It basically looks like 4 columns(A to D) full of data, from 1 to almost 800. My job is to ...
0
votes
2answers
27 views

How to deal with lines starting with '=' in Excel?

I want to obtain a simple CSV file that looks like this: Filename,Value1,Value2 filename1.ext,0.38,0.44 filename2.ext,0.60,0.50 ... However, -unfortunately- some of my filenames start with = and ...
0
votes
1answer
13 views

Subtracting from a SUM range by the number of positive entries returned?

So I have a Formula like this: =SUM(SUMIF(A1:A10,">0")-B1) But I want to subtract the value of B1 multiplied by the number of positive returns from the A1:A10 range. For example, if only 3 entry's ...
0
votes
4answers
69 views

Can Excel update sheet reference (like it can with cell) when I paste content of one sheet to another?

I have a document where I create a new sheet which represents days (has to be that way). Each sheet has a reference to the same cell in the sheet that represents the previous day. So sheet "Tuesday" ...
0
votes
2answers
49 views

Excel function that works out the average by first excluding all zeros and then excluding the minimum and maximum value

I have around 300 values on an excel spreadsheet (many of which are zero) and I want to work out the average by excluding the zeros, the highest value and the lowest value after zero. What would be an ...
0
votes
0answers
27 views

How to remove Excel password (I know the password) WITHOUT Excel?

Spent about a few hours scouring the net for an answer, but nothing so far has worked. I've tried DOCRECRYPT with absolutely no success, the certificate side of things are broken and there is no fix ...
0
votes
1answer
20 views

Excel - vlookup with multiple conditions

I'm trying to do a lookup in Excel based on the following. Situation - I want to look up what the speed limit is in a given section of road. Essentially the table I'm looking up specifies that the ...
0
votes
0answers
16 views

Excel VBA does not save file even when prompt says it will

I have an Excel file that generates reports using VBA. A portion of that process copies data from 1 file to append into another then saves the destination file. The process works on many machines ...
0
votes
0answers
13 views

Trying to automate a webpage that uses iframes. oie.document.frames(0).document.all.Oy [migrated]

I'm trying to create a budget program that will on open open IE and grab an available balance from an account. I have the login progress completed. But after the webpage loads, it starts to ...
0
votes
0answers
15 views

Field equals regular expression

In my excel file, I'd like field A2 to equals regular expression match of field A1. The regular expression is as follows: ^NATURE-[0-9]+ . Intuitively, the formula for A2 would be: =RegEx(A1,"^...
0
votes
1answer
37 views

Excel 2013 Wildcards on specific range and Sumif

I'm trying to use a wildcard limited to a specific range within a Sumif function. Example: I got these codes: ABC-1 ABC-2 ABC-3 ABC-4 ABC-5 ABC-6 And I want to SUMIF from ABC-3 to ABC-5. I found ...
0
votes
0answers
20 views

copy data from one opened excel workbook to another opened workbook excel VBA

I try to copy data between two workbooks which already exist but it didn't work. I don't know how to write a code without opening two files every time I run the macro. Sub CopyRangeToAnotherSheet() ...
0
votes
4answers
26 views

Excel 2016 not updating automatically even though automatic set in calculation mode

I set calculation mode to automatic but when I enter "=Now()" inside a cell I do not see the time updating even when formatting is changed to show seconds. That worked in prior Excel versions. Is ...
0
votes
0answers
10 views

Adding a 'connected file' link to an Excel Workbook

This is fairly specific, and I'm not sure if it can be done, but thought I'd ask. When you save a web page in Windows, you get the HTML file, and a folder called '[Title of webpage]_files'. The ...
0
votes
0answers
16 views

Excel SUMIFS Formula Sequential Date Criteria?

=SUMIFS($I$2:$I$2221,$M$2:$M$2221,"VISA",$B$2:$B$2221,"June 1") This is the formula I am using for a sales analysis worksheet, that takes the clutter from the POS report and breaks it down in a ...
1
vote
1answer
28 views

Single data series with both primary and secondary axis (in two different units)?

Is it possible to plot (line graph) a single data series and display both a primary axis and secondary axis, showing two different units? Currently I have the different y-axis units as a separate ...
-1
votes
0answers
11 views

Excell: send “Vlookup” dependent value to cell on a different worksheet

I have a excel workbook that uploads values into another program from WS2. I have added a separate data entry worksheet for each month of the year that calculates the value needed in column "C" of WS2....
0
votes
0answers
31 views

Excel - Keeping Original Cell Value with VLookup and Iferror function

I am stuck with a Vlookup formula I'm working with. I need to apply the vlookup formula to a whole column, but here's the catch - I need the formula to not do anything if it returns an error. There ...
0
votes
0answers
17 views

Object required error

Forgive me for trying to get into something way above my skill level but I am trying to write a macro in VBA to send data to a website and collect a quote and return it to the workbook but I keep ...
0
votes
0answers
17 views

Bug with grouping in Excel 2016?

For the group function in Excel, I am able to create groups and levels. However, it seems like if you group a number of rows, and then create a subgroup with the same last element, the "collapse" + ...
0
votes
0answers
24 views

Microsoft Excel reference a table into a single cell/single line

I'm creating a table in where i have references/formulas. I want to derive only values from the table and paste into a single line in the same sheet. Example: This is my table now: ...
0
votes
0answers
19 views

Runtime 1004 error involing Date

I'm working to get this Filename macro working and keep getting an error, the macro is as follows... Sub Sheet_SaveAs() Dim wb As Workbook Sheets("Sheet1").Copy Set wb = ActiveWorkbook ...
0
votes
3answers
85 views

Is there an inverse OR function?

The OR function returns TRUE if any of the arguments are true. Is there a function that returns FALSE if any of the arguments are false?
0
votes
0answers
27 views

How do I convert multiple rows into one column

How do I convert multiple rows into one column? I have data in rows containing 3 columns: Name | Mob. No. | e-mail I want to transfer Mob. No. & e-mail into another row without changing its ...
0
votes
1answer
17 views

How to visualize a point series within a grouped bar chart in Excel?

I have created a grouped bar chart within Excel, that shows the mean wage of men in different countries (y-axis), represented by different occupation groups (categories). Now I want to enhance the ...
0
votes
1answer
21 views

How do I expand a row into multiple rows with the same data in each row based on the number of the current cell?

Row 1-4 is the example of the data I'm given and I'm trying to achieve rows 7-17. The real list I'm working with is over 10,000 lines long, so if I can use the same formula on the entire list that ...
2
votes
1answer
31 views

Locate Excel Autosave recovery files in Finder

I was working on an Excel file which I had saved earlier when my MacBook crashed (several hours between manual Save, extremely repentant at the moment). With help from another thread (Locating ...
1
vote
2answers
25 views

How to link 2 Excel files located in different PC's

I have one Excel file in my laptop and another in my desktop on the office of the work place. How to connect them together?
2
votes
1answer
54 views

Macro to autofill columns in Excel

I've recorded a macro in Excel that fills the columns with formulas.  However, it's limited to the range I was using in my test data, i.e., it doesn't fill down to the last row of data when I use a ...
0
votes
0answers
19 views

Prevent formatting of new row in Excel table

I'm writing an add-in for Excel in C#, and I'm doing my own validation. I color cells in green when the input is valid, and in red when the input is invalid (see example below). So far so good: ...
0
votes
0answers
20 views

getting a cell to reference itself (need it for conditional formatting)

My spreadsheet involves highlighting cells that have values that are also found in a separate range. When using a formula to apply a rule in excel im not sure if the syntax is the same. It says: "...
0
votes
1answer
18 views

Dynamic Yearly / Monthly Charts in Excel

I would like to create a dynamic line chart in Excel. The objective is to view a specific timeline inputted by the user. For example, if I want to view the first 12 months of data, the chart will show ...
-3
votes
1answer
34 views

Count in column B if column A=x

In Excel, I want to count the number of Y in column B if column A equals F. Does anyone know the code? For example, in column A, I have people's gender. In column B, I have if they are pregnant or ...
0
votes
1answer
23 views

How can I select the whole string except for the first character from a cell in Excel 2007

I have multiple tables where 1 column contains a string which is a combination of a letter and a number. For example these values can range from B1 to B1000000. My present solution to automatically ...
0
votes
0answers
22 views

Excel formula to match all the possible substrings from a cell to another string

I would like to come up with a formula in Excel to try to find an exact match of any sub-string in column D to any string in columns A, B, or C. I have a list of all the states (column A), counties (...
1
vote
1answer
39 views

Excel to count number of concurrent sessions based on start/end times and PC Name

I know there is a very similar thread to the this one already – Excel to count number of concurrent sessions based on start/end times – however, as much as I try, I am unable to replicate and ...
-2
votes
0answers
18 views

In excel my formulas have stopped working. When I copy a formula if gives the same answer for the wrong data

I have a set of columns with a sum at the bottom of each. One formula in one column has stopped working. If I copy the formula from another column, it also copes the answer...
0
votes
1answer
24 views

Embed OneNote in Excel

I know it is possible to embed an Excel sheet into OneNote... but is the reverse possible? My end goal would be to have a OneNote page directly in my worksheet, so the user can write in OneNote from ...