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
1answer
12 views

Mailing multiple mailto: links in an Excel spreadsheet

I have an Excel spreadsheet that has a list of mailto: hyperlinks in one of the columns. I'd like to be able to send an email to a selection of them, but clicking on one- even as part of a selection- ...
1
vote
3answers
17 views

How to combine values from multiple rows into a single row? Have a module, but need the variables explaining

I'm completely new to VBA and trying to implement the excellent looking solution here by Raystafarian How to combine values from multiple rows into a single row in Excel? (the revisited version). ...
0
votes
1answer
11 views

Lock Drop Down Cells and Enable Use - Excel 2013

I would like a drop down list in a cell. I would like to lock the cell so it cannot be moved or altered but changes other than selecting from the drop down menu.
-1
votes
0answers
11 views

Excel formula where the outcome remains unchanged when values change in future

A B C 1 Area constant Land value 2 0.2500 200,000 50,000.00 3 0.3650 200,000 73,000.00 4 1.2540 200,000 250,800.00 5 0.2580 ...
2
votes
2answers
21 views

EXCEL HELP in transposing the columns to rows

Input : MACK 113 445 25 JACK 345 PIKER 30 23 I want the output to be : MACK 113 MACK 445 MACK 25 JACK 345 PIKER 30 PIKER 23 Can anyone please help me out . ...
0
votes
1answer
16 views

If < formula is not working on all my cells

I need to determine if my players play slots or tables based on if they have higher slot or table points.I typed in the formula =IF(D2
1
vote
1answer
16 views

AVERAGEIFS values that are not NA

I have the following AVERAGEIFS that averages column I grouped by the values in column B = AVERAGEIFS(B:B, A:A, A:A) Problem is, sometimes, the column I sometimes contains an NA() error. How do I ...
0
votes
1answer
17 views

Keep command button visible while scrolling down worksheet?

Is there anyway to keep a command button visible and while you are scolling down a long worksheet, you can still see the button scroll with your worksheet? I know there is the freeze pane but I would ...
0
votes
0answers
15 views

How do I make form fill out to different sheets based on the month?

I have an exercise and diet log that I fill out every other day and I want the data to move to another sheet. Sheet 1 looks like a worksheet and I want it to move (I think the best way to do this is ...
2
votes
3answers
32 views

Excel Formula-Return Value based on looking at two separate values (either/or)

I am using this formula to return a value from table below: =IF(ISNA(VLOOKUP(A2,USUB,1,FALSE)),"No Fruit Found",VLOOKUP(A2,USUB,2,FALSE)) USUB table has this data: Fruit Fruit Code ...
0
votes
0answers
12 views

Matching postcodes on 2 worksheets. Looking up corresponding data and recording alongside postcode

Two tabs in an Excel 2013 spreadsheet. One tab is named Homes Data and the other tab is named Ratings Data. Column O in the Homes Data tab is a list of postal codes and column G in the Ratings Data ...
0
votes
3answers
16 views

Variable sliding window in Excel

I am using Excel 2010, but I presume this would be solved the same in any version of Excel. I have data that I would like to sum - essentially providing a sliding cumulative value. For example, on a ...
0
votes
1answer
15 views

Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text. =SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop")) I need simpler formula to count rest ...
1
vote
2answers
16 views

Total value based on column conditional

In the following image, how could I get the values for cells C9, C10, C11? In case it's not clear, what I need is for a function that will return the value of a cell in column C, depending on the ...
-2
votes
0answers
21 views

Excel 2010 and VBA

I'm having trouble setting up a VBA script to successfully run in Excel 2010 page set-up. I was hoping to automate adding a repetitive Header Title, top right page x of x, and LFooter stacked ...
0
votes
0answers
10 views

Create table out of existing table matching a condition

I want to create a table in Excel that extracts the part of a table that matches a certain condition. If possible without using macros. Here is a plot: A B C 0 1 6 2 12 3 18 ...
0
votes
2answers
48 views

How do I graph this on excel?

Is it possible to have an x-axis with subgroups? For example, I need to graph Categories: Greeting (1.1, 1.2, 1.3), Call Reason (2.1, 2.2, 2.3, 2.4), Conclusion (3.1, 3.2, 3.3) , Accuracy (4.1, 4.2, ...
-1
votes
1answer
25 views

Controlling formatting when importing data into excel spreadsheet

At my company, we use an electronic visitor sign-in/out system via an app titled Envoy. The data from the application can be exported to Excel from the admin interface on the host-site by clicking a ...
-3
votes
0answers
21 views

How to create a macro that pulls data into one summary sheet from multiple sheets? [on hold]

How do I create a macro that pulls data into one summary sheet from multiple sheets? I need the macro to filter on one column (the status column) in every sheet, and not bring over the rows that have ...
0
votes
1answer
25 views

Need to Reference multiple sheets with IF(OR(AND( imbeded

I need to reference 3 sheets, "Shipping", "Equipment", and "Inventory", where Column A in Shipping and Column A in Equipment both refer to the Location Number, and Equipment Type is designated by text ...
1
vote
2answers
106 views

Conditional formatting on the first x number of rows, regardless of filter or sort, in Excel

I'm trying to find a way to easily identify the first ten rows in a table column, no matter how it's been sorted/filtered. Is there a way to use conditional formatting to highlight these cells? ...
3
votes
3answers
255 views

Is there a way to copy from excel to word without format getting changed?

Is there a way to copy from excel to word without the format getting changed (for example if you use a size of 6 in excel, which is not supported for the same font in word)? Currently I'm doing int ...
-1
votes
0answers
16 views

VBA code to hide rows when 2 columns both have the value 0 [on hold]

Good day, I please enquire about VBA coding in order to hide rows if two adjacent columns (columns G & J) BOTH has the value 0 in them. Rows should stay unhidden if either column has a value in ...
0
votes
1answer
36 views

Displaying ONLY hours and Minutes in Excel

Using Excel 2010. I'm not an Excel neophyte as I've been using is since the late '80s, but haven't had to do this before. I'm building an agenda for a meeting where I want to display the start ...
0
votes
1answer
15 views

Find specific matching values of two columns in excel

I have spreadsheet like the following. In that columns detection_BaP1 and detection_NT1 are having Absent and Present. I want to add a new column Global_detection with Absent and Present If both ...
0
votes
0answers
16 views

Why does Formula Auditing | Trace function become disabled

Why/How does a workbook suddenly have Trace Auditing disabled (not protected)? What causes Excel to activate this behavior? I was working on an Excel spreadsheet that I had created a while back and ...
0
votes
1answer
24 views

how to sort the data with defined min and max value

I am looking for generating the number of entries which fills into defined min and max values from the given data. To put it more simple, If the data set is Roll No: 1, 2, 3, 4, 5, 6, 7, ...
0
votes
1answer
14 views

Excel - Multiplying daily values for each week

What I have: over 200 rows, each with three values, each for a unique day. Only values for workdays are listed, so sometimes there may be days or even whole weeks missing from the list because of ...
-1
votes
0answers
7 views

How to run saved SAP Script directly from excel using macros

I have saved a script that I usually use on sap; but I want to have a macro that enables me to click a button on excel that runs this script, which is saved in a certain path.
0
votes
1answer
17 views

Quickest Way to Extract Data from Doc or Pdf to Spreadsheet [on hold]

I have an influx of reports coming at me, and I need to extract some of the data and put it into a better format(an excel worksheet.) The reports come in docx or pdf and look something like this. ...
-2
votes
0answers
24 views

Automatically Delete Incorrectly Spelled Words from Excel Spreadsheet [duplicate]

I have an Excel spreadsheet which consists of thousands of word entries. I would like to have words that are spelled incorrectly, according to the Oxford Dictionary, be highlighted in the Excel ...
-1
votes
2answers
38 views

Automatically removing invalid or gramatically incorrect entries in Excel

I need to clear out all the incorrect data from my Excel sheet, such as grammatical mistakes and invalid entries, and I want to do it automatically. I have tried the sort and filter option, but it ...
0
votes
2answers
35 views

commas as text in CSV

How can i get this entire string to be imported into excel from CSV as one column (read the comma as text in the string, not a separator)? ...
0
votes
2answers
43 views

Excel - named ranges fill

I want to do the following: for the first row in Excel, create a formula with named range. say: A1=1, B1=3. Create named range A1:B1 called "amounts". cell C1=sum(amounts). this makes row1 very ...
1
vote
2answers
13 views

Excel 2016 for Mac - Add row shortcut

I'm looking for a shortcut to add a row above the current cell in Microsoft Excel 2016. I hate using the mouse. I saw Ctrl + space, Ctrl + i, but it makes the contained text italic.
0
votes
2answers
24 views

How to permanently color a column in Excel

How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it ...
0
votes
2answers
19 views

If a range contains specific value, how to produce a percentage of that range below the specific value in Excel

I'm stumped. I am arranging a data set that contains ranges of numbers that are specified by two columns, the minimum and maximum values (sometimes these values are the same). I am interested in the ...
0
votes
0answers
12 views

Screen changes randomly while entering data in cell

The screen changes up or down as I enter the data in a cell, once I press enter the screen moves back to the selected cell. I have the same problem while using Word.
-2
votes
0answers
35 views

Compare two Columns and delete the gap Using Macro

I have an Excel file and i want to compare the date in columns A and D and delete the gap between them. For example based on this picture: Time in column A start at 15:25:15 and in D at 15:23:52. ...
0
votes
1answer
22 views

How do I identify partial duplicates in an excel list?

I have a list of over 1000 company names, however some are duplicated but they aren't exact duplicates (ie: Nintendo, Nintendo Inc, Nintendo Video games, etc), is there a way to identify the ...
1
vote
1answer
33 views

Generating Repeating Data

I have 4 data items in column B. Initially I needed to fill another column with the original data repeated 7 times. So the first item should appear 7 times, then the second item should then appear 7 ...
0
votes
0answers
33 views

White space between columns in Excel

There are white spaces between columns in excel when I have conditionally formatted them to shade depending on row. How can I fix this?
0
votes
0answers
31 views

Problems with excel formula

I created a sheet with tables and I duplicated that sheet to create 3 more. Then I added formulas in tables in first sheet where I used table cells from other sheets. All formulas were structured ...
0
votes
1answer
18 views

How to assign a unique text per group of entries in a column?

I have a list of employees in Column A and a location in Column b(empty). I need to assign a location for every twenty employees which its value on another sheet on column a. thanks
-1
votes
0answers
19 views

enroll employees different labs [on hold]

i have a sheet (column a) serial from 1 to 9000 , (column b) employee name ,(column c) training lab no# and another sheet that have a list of training labs(training lab no1,training lab ...
1
vote
0answers
27 views

Excel doesn't create structured formula for all tables

Structured formula case I am facing 2 weird issues with Excel 2013. I have been mainly using the tables. Initially when I created the sheet and inserted tables and added formulas, they were all using ...
0
votes
0answers
21 views

Windows 7 Professional Taskbar Grouping Disappears (Not using Aero Theme)

I like using the grouping function with Windows 7, yes our company is still on Windows 7. However, when using Outlook 2007, ("yes 2007") and excel 2007 when I have multiple emails or excel files open ...
0
votes
0answers
25 views

How to assign different sets same value…? [on hold]

I have a list of employees as a serial that starts from 1 up to 600 and I need to assign every 20 employee starting from 1 to different location and what if I needed to assign every location ...
0
votes
1answer
33 views

Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format: A|12 B|23 C|98 A|66 D|86 E|3 B|25 A|65 . . . The values are simplified for the ...
0
votes
0answers
15 views

How to insert online pictures into excel with VBA

I want to add images from my web image repository so I have all the hyperlinks in row 3 (C3:L3) and in row 2 (C2:L2), I would like to automatically insert the image whenever I press the Display image ...