**1**

vote

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**3**answers

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

**0**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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