**0**

votes

**1**answer

10 views

### Counting the repeated text in another sheet

I have to count the repeated text of a cell which is in another sheet.
Like
How can I do it?

**0**

votes

**1**answer

49 views

### Excel 2010 formula?

I need help with a formula for the following:
L6 needs to show a date which is the date in K6 + the value (days) in J6. However if there is no data or only text in either K6 or J6, cell L6 should be ...

**0**

votes

**0**answers

17 views

### My 'show items with no data' option is greyed out in Field settings

I want to set my pivot table to show no data items, I normally click on 'show items with no data' in field settings however this option is greyed out for me. I have also tried using 'show items with ...

**-2**

votes

**0**answers

16 views

### Combine Certain Part of Certain Tabs From Hundreds of Workbooks

I'll try and be as clear as I can. What I need seems very simple but I'm really struggling (I'm fairly new to VBA).
I have 700 separate workbooks that I need to combine, removing the duplicates as ...

**1**

vote

**1**answer

34 views

### Excel - List data from 4 columns

I have an excel sheet where I want to make a list based on data in 3 columns. See the image for how the basic things looks currently.
I have names in column A and then in column B,C and D is a ...

**0**

votes

**0**answers

10 views

### EXCEL 2016 PowerQuery in a Remote Desktop Session Host (RDSH)

In Excel 2016 on a RDSH when I create a simple query ( select * from table1 --with have only 152 rows) in power query editor it runs Ok and load all the 150 rows.
But when select close and load only ...

**0**

votes

**1**answer

28 views

### Excel 2016 - If a cell equals 1, then output new number

I have an output (Column AL) which either equals 1 (option wanted) or 0 (option not wanted) on column AM, there are many options which I want to identify with unique numbers 1,2,3,4,5,6,7,8,9,10 etc (...

**0**

votes

**2**answers

31 views

### Rigorous Email Validation in Excel 2013

I am using Excel 2013. I am building a form that the end user will fill in.
I have a cell for users to enter their email address, and I want to build a thorough email validation. I searched a lot ...

**0**

votes

**1**answer

20 views

### Create hyperlink to folder if folder with same name exists (Excel)

I have an excel document and column A is just a list of numbers, my case numbers at work. These numbers a flowed in regularly from another document and are regularly updated. I have a folder called "...

**0**

votes

**1**answer

16 views

### Need formula to add enough zeros to total 10 characters

I need to tweak the below formula, so that instead of always adding 5 zeros, it adds enough zeros to equal 10 values (characters). I'm using this in a system (iCIMS), and the result (depending on the ...

**2**

votes

**2**answers

36 views

### Searching an array from bottom to top

I have a table array $E$14:$G$851. Column E just contains unique identifiers, lets say a/b/c/d etc, column F contains hundreds of numbers all less than or equal to 20 and column G contains the values ...

**0**

votes

**0**answers

25 views

### How do I add multiple date values?

I already used the function
=IF(AG2<(TODAY()+2),"DELIVERY DATE",IF(AG2<(TODAY()-1),"DONE","ON GOING"))
but the value of "DONE" is not working. Please help me out.
This is the criteria:
if ...

**0**

votes

**0**answers

19 views

### Separating two runs of data

I am taking data measurements on a machine (measuring laser power) It runs at 10% power, then 25%, 50, 75, and 100 with cooldowns in between for two separate optics. Each run is not a constant length ...

**0**

votes

**0**answers

28 views

### Taking multiple averages from one set of data

I have a machine spitting out data files that I want to analyze quickly. There is one column of data (thousands of readings). These values are laser power readings. The machine has two lasers and it ...

**0**

votes

**1**answer

10 views

### Filling In Next X Filtered Rows Automatically With Formula or Value in Excel

I was wondering if there was a method in Excel to fill in the next X number of rows in a blank column if the dataset is filtered. So for example, if I have the following filtered, fictitious data set:
...

**0**

votes

**1**answer

22 views

### excell & csv is converting my tell no to not have +

I have tried several tricks and none of them are working i have tellephone numbers '+4 55 555 555 555 and in excell the cells that have the little green triangle warining sign, they loose the +4 and ...

**1**

vote

**3**answers

71 views

### Excel has file big size

I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns.
Each day we create a copy of this file, and in the new copy, change the numeric value of 20 cells.
No ...

**0**

votes

**0**answers

20 views

### Excel - reformatting a record into several rows

I'm try to figure out how I reformat data from one row per record (each record is a person's details) into several rows for each record, identified by a reference number. My data currently runs A - Y ...

**0**

votes

**0**answers

12 views

### How to edit a shared excel addin that is read only (and block it from locking in the future)

I created a useful excel addin that builds an automated report.
The addin is shared on a server where a few people use it, but I recently found a small bug I want to fix - however when I open, edit ...

**0**

votes

**2**answers

22 views

### How to calculate revenue equally based on start and end dates?

My company phases revenue based on slightly obscure start/end dates and I need calculate how much revenue falls into the current year, based on these dates.
If a contract starts on or after the 16th ...

**0**

votes

**1**answer

33 views

### Excel: A macro to minus a certain number from a column of cells every 24 hours?

I have two columns. The first has 'Usage per day' and the other has 'Amount in stock'. I need a macro that would take the usage per day from the amount in stock every 24 hours so that I will know when ...

**1**

vote

**1**answer

21 views

### MS Excel. Column product syntax so it returns an array instead of SUMPRODUCT

I want to find the largest number in the column that results from the multiplication of two columns. Is there a way of doing this directly without having to use the C column? I would like to do it in ...

**-3**

votes

**0**answers

17 views

### I have window 7 ultimate and office 13 [closed]

I have a file of 8 spread sheets of one parameter but different names and coresspoding expression values in each of 8 values, so i want to find out common in 8 or any two how ca i do that

**0**

votes

**1**answer

20 views

### Excel formula to read 2 of 3 cells repeating or not

I am having trouble getting a formula that will work the way I want:
IF 2 or 3 of the last 3 cells (A2:A4) were b, AND cell A5 is b, then C5=+, otherwise -.
IF 2 or 3 of the last 3 cells (A2:A4) ...

**1**

vote

**2**answers

18 views

### Need to update pricing in a spreed sheet from a separate sheet. Excel 2016

I have 2 sheets.
One 'Content' has Product Code in A11-A2912 and Price E11-E2912, and some fields are blank.
The new data is in a separate sheet 'New Price Data' with Product Code in A1-A1409 and ...

**0**

votes

**0**answers

8 views

### Update column / row labels of pivot table from a named range

I have a pilot table with one column label and one row label, like this:
Month: Jan Feb Mar ...
State:
-Texas
-Illinois
...
I want to be able to choose which states to display AND in which order ...

**0**

votes

**0**answers

16 views

### Excel - How to calculate attrition over large database

I am analyzing a large database where I need to figure out how many customers bought the product more than once and determine how long they "lasted" as customers. My data set starts in Jan 2014 and ...

**0**

votes

**1**answer

28 views

### Excel 2013 conditional formatting

I have data in multiple cells in a row. I want to highlight cells A to K based on cell L value (text from a list). Further to this if I place any text to cells M or N or P then all the highlights must ...

**0**

votes

**2**answers

36 views

### Making Text To Columns Range Dynamic

I would like to make the text to columns range dynamic in my macro.
But if i try to put the myRange in there it doesn't work.
I can't find any information around the web to make the text to columns ...

**1**

vote

**1**answer

34 views

### Excel merge cells, keep values, collapsing chart

Imagine a chart that looks like this (rows 1,2,3 are merged in columns B,C,D):
A B C D
1 th
2 in ## ## ##
3 g1
4 th
5 in ## ## ##
6 g2
I want a chart that looks like ...

**0**

votes

**0**answers

12 views

### Excel 2016 - Need Help Finding a Value in Two Separate Worksheets [on hold]

I have several worksheets; two specifically have columns of Account IDs that are common. One column's data on WKSHT 1 is in A, the other column in Pivot Table is Column C. I'm trying to match the ...

**1**

vote

**1**answer

24 views

### Convert a typed date into a date formatted cell in Excel

We have an excel file with a column called "Date", inside of which is some text, such as 28th February 2016.
How can we format this like 28/02/2016? I've tried using the format cell function but ...

**0**

votes

**0**answers

17 views

### How to print multiple filters of a pivot table at once?

I have a pivottable with filter. The filter contains a list from 1 to 20, each of which must be printed separately. That is, each time I have to change the filter and print the filtered result.
Is ...

**0**

votes

**1**answer

29 views

### VLOOKUP across multiple worksheets in different workbook (Excel 2010)

Apologies if I placed this in the wrong place.
I am trying to create a VLOOKUP across multiple sheets in from another workbook, all the sheets have the same data and same layout, the VLOOKUP is in a ...

**0**

votes

**1**answer

20 views

### Excel - switching names in a cell

I have a list of peoples names in one column, showing first names first.
I want to sort them in alphabetical order of surnames.
Is there a way of doing that without changing the text around, and if ...

**0**

votes

**1**answer

20 views

### Creating a “grouped” bar chart from a table in Excel

Firstly, I have almost no experience with Excel charts. :)
I'm trying to create a fairly simple chart from a fairly simple table. But I'm having more problems than I thought I would have and spending ...

**4**

votes

**1**answer

22 views

### Alternating color in visible rows based on column value in Excel

This is similar to Alternate grid background color in excel when a value of a single column changes? , and I believe it can be done using SUBTOTAL(109,... , but I can't quite figure it out.
The first ...

**-2**

votes

**1**answer

25 views

### Excel - Assistance with if functions summing up in a common cell. [closed]

I am trying to make a cell display a value dependent upon the value of another cell. e.g. If cell A1 contains "1st" i want cell b2 to calculate that as the number 25. Easy enough, but the trick is i ...

**0**

votes

**1**answer

19 views

### The zoom setting changes & screen bounces when typing

I'm having ongoing issues with the zoom setting changing by itself and the screen bouncing around while I type a message in gmail or make an entry on an Excel spreadsheet. What could cause this ...

**0**

votes

**0**answers

21 views

### Can you have 2 excel spreadsheet in the same workbook have the same exact name?

I am working on a test .
there is a question that baffles me . They are asking to rename the excel spreadsheets which is fine . At some point in time they are asking for 2 spreadsheet to have the ...

**0**

votes

**2**answers

29 views

### Excel reverse range

When doing a MATCH or anything that returns the first result in a range (say A1:A10) is there a way to reverse the range (A10:A1), such that the it effectively returns the last result? Currently, ...

**1**

vote

**1**answer

15 views

### How do I return a value that is not in it's own row?

I have a list of serial numbers that have different scan dates:
Serial # Started Ended Prev
A: L50099 28/02/14 11:50 AM 28/02/14 3:20 PM
B: L50099 25/11/15 ...

**3**

votes

**2**answers

68 views

### In Excel how can I search for #N/A cells?

I'm trying to go to the first instance of a #N/A cell, the result of a VLookup that failed.
I know I can conditionally change the value when the result is #N/A, but what I want to do is just locate ...

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

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