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)

0
votes
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
3answers
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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
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
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
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 ...