**1**

vote

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**4**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**4**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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 ...