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 "VBA". If it is about an Excel formula or worksheet function, then also tag it "worksheet-function".

learn more… | top users | synonyms (2)

0
votes
0answers
3 views

Excel will not put information in cell?

I am entering data in one cell in excel and it will not put information in the cell. Will work in all others however. Started when I was simply trying to cut and paste a confirmation number.Number do ...
0
votes
1answer
10 views

How to grep summarized value from excel cell range?

I've very basic knowledge in excel and I don't know too much about excel function. I want to get summarize information from the following sheet. I don't know how to summarize this information. My ...
1
vote
4answers
4k views

excel / google spreadsheet: count substring occurrences within a cell

I've been scratching my head trying to figure out a way to count the number of occurrences of a substring within a cell. For example: | | A | | 1 |John,John,Tom,David| What ...
0
votes
0answers
9 views

Auto-Fill data between two spreadsheets, adding new row, keeping same column, when new val

So I have a list of items that need to be constantly added to a list for auditing purposes. Problem is, the item names constantly change and also on occasion, new items are added. Essentially, I am ...
0
votes
1answer
31 views

how do assign numbers to text and then add or subtract them?

Hi could you advise how i create a formula for the following spread sheet? the text all have same value (AB=1) BC=1) (CD=1) etc. I want to place the text in a cell to place order, the text should ...
2
votes
2answers
4k views

Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY) Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...
1
vote
0answers
12 views

Shortcut for Direction Keys — To keep hands on QWERTY end of the keyboard

I use a lot of Excel and finally got myself used to the ThinkPad pointer whereby I no longer need to take my hands off the keyboard for scrolling. But now I need to take my right hand off the ...
0
votes
1answer
4k views

How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...
0
votes
2answers
3k views

How to format excel cells that show duration in years and months?

I can't figure out how to do custom formating that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...
2
votes
2answers
58 views

How to remove linebreaks in Notepad++? in long text

I would like to know if is a method to remove linebreaks in Notepad++ aside from select and cntrl + J that is already explain here How to remove linebreaks in Notepad++? the Problem is ...
0
votes
2answers
21 views

Adding components of formula (net vs. gross)

I would like to add the components of a formula across a range. We have one section that shows the net cash flows for specific items, and multiple specific items. For example =8+9-5 shows "12" ...
0
votes
1answer
15 views

View code in Excel - Import_Journals

I'm trying to look at some VB code in an Excel macro. This code is executed on a button click: Private Sub ImportSelected_Click() Call Import_Journals("SELECTED", "IMPORT") End Sub I want to ...
2
votes
1answer
79 views

Excel - Vertical scroll columns A, B, C, D, E but F, G, H stay the same?

I know I can split at column F and each will scroll individually horizontally but I want them to independently scroll vertically. Is this possible? Here is a fiddle of an example of what I want in ...
-1
votes
0answers
14 views

How can I automate the process of printing 2 rows of data from one sheet after pasting it onto the form on another sheet?

Sheet 1 of my spreadsheet has the following form: A B C D They are just columns named 'A','B','C' and 'D'. Sheet 2 has the following data: A 1 2 3 4 5 6 7 8 9 10 I want to print pages of ...
0
votes
1answer
16 views

Clamping values while averaging

I have two formulas that are calculated using the same dataset. One formula calculates the average of the values, while the other calculates an average with a maximum allowed value of 60. I'm ...
0
votes
0answers
17 views

Excel Updates Link In Other Workbook

I opened two spreadsheets from an email, spreadsheet June & November. Both June & November in cell A1 reference a [CashInput.xlsx]CashInput$A$1 that was saved on the spreadsheet creator's hard ...
2
votes
3answers
7k views

only show pivotchart not pivot table

I see that I can only create a pivotchart from a pivottable, but since the filtering options are on the chart, and the table is not important: Is there a way to hide a pivottable If I only want to ...
0
votes
0answers
20 views

Word Mail Merge with Excel - Can't open both at the same time

I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the ...
0
votes
0answers
12 views

Replacement of a string in excel with another string, taken from a csv file

Say I have a CSV file which looks like "5.2", "Blah Blah Blah" "5.3", "Bleh" "5.4a", "Unicorns" Now, how would I go about creating a script or macro of sorts(?) so that whenever I type ...
0
votes
0answers
10 views

How can I create multiple charts based on a series filter using PivotChart?

I have a pivot table/chart displaying sales(value) by week(axis). I can add the branch to the legend and get one chart that displays the sales by week by branch. The problem is that I have 100 ...
0
votes
2answers
20 views

How can I find the Maximum of Polynomial Trendline?

I have a XY chart. I used a polynomial trendline, now I need to find the maximum of the chart in an automatic way. Is it possible? Here is a picture to show the type of chart.
0
votes
0answers
21 views

Split single row into multiple rows in excel

I have a file of data formatted in the following way contractID, typeofreview, rq#, q1,q1a, q2, q2a, q3, q3a, q4, q4a 0001 basic 15 Ht Y Smk Y Sur Y Rsk Y 0001 ...
0
votes
1answer
22 views

Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file. I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...
2
votes
4answers
14k views

Excel text alignment with custom formatting

Is there anything in a custom formatted formula which defines the text alignment? I know the different parts of the formula is numbers, negative numbers and so on, but I need to set the alignment. ...
0
votes
3answers
3k views

move worksheet to another workbook, without the vba code but keeping the colour scheme

I current have some code that first copy a worksheet do some cleaning and then move it to another workbook. My problem is that when i copy or move a sheet it also copies the vba code that is attached ...
6
votes
2answers
71k views

Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 ...
0
votes
0answers
23 views

Group different values with same name field in Excel

I'm having troubles with the following document. Is there a way to group different values with the same name field?
2
votes
1answer
24 views

VBA EXcel - I am getting an error (400) if using error trap getting no object/application defined error

My excel sheet has these data, 7 columns sl.no | bed | 2| 4| 3|4|3| some times column no 7 is empty, and then only I'm getting error And my code Sub sup_cal_area_sft() Dim lru, plru As Long Dim ...
0
votes
1answer
18 views

Color a cell in MS Excel sheet, if do not fall in range

We need to enter lots of data in a excel sheet. Later we want to color code that data. I will be the one preparing this excel sheet and sharing with team. What I want is the moment I put a number and ...
2
votes
1answer
6k views

COUNTIFS over multiple worksheets

I am trying to make COUNTIFS go across two worksheets in the same excel file (Final Driver Forecast Model), just on different tabs. I need it to count if a driver returns between a certain time, then ...
5
votes
2answers
22k views

How can I make Excel fetch data from a database automatically when I open the spreadsheet?

I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). ...
0
votes
1answer
3k views

How to combine Excel charts on same X-axis

I want to create two stacked graphs in one chart object. One should be Stacked Column, and another Stacked Area. They represent revenue per partner per week of the year. On x-axis are weeks of the ...
2
votes
2answers
1k views

Why is Excel 2007 backwards?

I opened up Excel 2007 and this is what I see: Where the row headings are on the right and the columns are backwards... Does anyone know what is going on and how to fix it?
0
votes
1answer
529 views

Combine duplicates in Excel based on values from 2 columns, produce the sum and and % from others, remove dups

I have been struggling with my Excel report trying to roll up duplicate rows based on 2 column values. Also need to calculate the sum of the 3rd and 4th column and calculate the percentage. Here is ...
0
votes
1answer
25 views
1
vote
4answers
46 views

How do I add 1 year to a specific date once that date has passed?

I have an excel spreadsheet that lists our current subscriptions. I have one column with the Date they signed up and then I have another column for the Renewal Date. Currently I have to manually ...
0
votes
1answer
3k views

Syncing two sheets, while being able to hide different data

I'm pretty new to excel- so please bear with me. I have created a spreadsheet to organize gear by serial numbers and by who has it. This list is getting updated multiple times daily as gear shuffles ...
0
votes
0answers
33 views

Highlight lines of text in text box based on selected flowchart item

I have a simple flowchart, and next to it I would like to place a textbox containing more detailed information on that chart. Is it possible to have an area of the text highlighted when a flowchart ...
0
votes
2answers
37 views

If cell contains “Specific Text” return value of cell beside it. Similar to VLOOKUP

I have 2 sheets, one with a list of parts(sku) and all the vehicles that the part will fit on (fitment) separated by "^^" it looks like this: sku | fitment 1 |car1 ^^ car2 ^^ car3 2 |car2 ^^ car3 ...
-1
votes
2answers
27 views

how can i make my macro toggle a sheets visibility/hide?

i have the following code that i want to toggle a sheet being visible or being hidden: Sub toggle() If Sheets("Navigation (2)").Visible = True Then ActiveWindow.SelectedSheets.Visible = False ...
5
votes
2answers
14k views

What excel formula can I use to calculate the 2nd Monday of a given month?

What excel formula can I use to calculate the second Monday of a given month? You can assume I have a cell containing the first day of the month to work with. In the interests of other users, can ...
1
vote
1answer
214 views

Word and Excel crashes when attempting to display file menu

I have an issue with my Office 2016 install, which I've installed through my employer's Office 365 subscription on my home PC with Windows 10 Home on it. I've installed the 32-bit version of Office ...
1
vote
2answers
3k views

Excel: How to plot a stacked scatter set

I have two datasets that share the same x values, but each have different y values. I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...
4
votes
2answers
305 views

Generate Combinations in Excel

I have an input row which contains the cells: 30 30 30 50 50 60 100 I want to generate all possible combinations of length 3 from this set. So I would want rows containing 3 populated cells and ...
2
votes
4answers
2k views

Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...
-1
votes
1answer
44 views

Formatting any cell referenced in a Formula

I have two sheets, one with formulas pulling data from the second. I need to create a macro or some conditional format to highlight the cell green if the data was pulled from the second sheet. sheet ...
0
votes
1answer
3k views

What formula do I use to work out a percentage of tasks complete in Microsoft Excel?

I have wrote a "y" in the cells where the task has been completed and a "n" where they havent. These are in D5:CI5. I want to work out their percentage in cell C5. I looked up other answers but ...
0
votes
1answer
16 views

How do I insert rows in multiple excel tables simultaneously without vba?

I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible? The tables are in different sheets if that matter.
0
votes
1answer
15 views

Excel Macro to draw xyscatter plot out VBA

I am trying to create a xy plot where the x values is the time axis (column A) and the y values are in the other columns. (in the example only C and D) When I try my code from below, I get a graph ...
2
votes
2answers
9k views

Flip x and y axes in Excel graph

This should not be very difficult, but I cannot figure out how to do it. I have a table similar to this %low %high 0 0 12 1 13 26 ... 19 90 94 20 95 100 When I graph it, excel ...