**0**

votes

**1**answer

13 views

### How to display unique numerical values from different columns into a single cell (separated by commas)

I have a unique problem I have been trying to tackle with no avail.
I have scoured through the internet but only found partial solutions and not a complete solution.
I am looking for a function (or ...

**0**

votes

**1**answer

16 views

### How can I count unique comma-separated values - Early Bound vs. Late Bound

I am trying to display unique values from a string of values in a single cell.(separated by a comma).
I've come across this solution:
How can I count unique comma-separated values in Excel 2010
...

**1**

vote

**1**answer

17 views

### How do I convert data for height that's in multiple formats into inches?

I have a column with several thousand heights, in different formats, that I would like to convert to inches.
Examples:
5 ft 2 in
6 feet 3 inches
5*8
5.3
5'10"
I'm thinking there is some way to ...

**2**

votes

**1**answer

21 views

### How can I look up the 2 axis values by inputting a number?

I'm a graphic designer and not very familiar with Excel but I'm fairly sure it's the simplest solution to my problem. I have a table (see below) with 2 axis going from A to L. Inside that table are a ...

**2**

votes

**1**answer

27 views

### how to you keep a formula to stay with a certain cell even when you insert a cell to the right

I have a date in cell D3 AND THEN IN CELL C2 I HAVE THIS FORMULA:
=DATE(YEAR(D3)+1,MONTH(D3),DAY(D3)-1)
Which adds the date for review a year on. but when I need to insert the cell to the right to ...

**0**

votes

**0**answers

9 views

### Designate Excel Data Connection ReadOnly

I have an Excel file with a data connection to another Excel source which is referenced by several other reports. The data connection should be read only, but I cannot seem to setup the properties to ...

**1**

vote

**2**answers

32 views

### Microsoft excel - formula dragging

How can I drag a formula to all the adjacent columns with similar intervals in it?
For example:
in column F, the formula is ('Time sheets'!G10-'Time sheets'!F10)*24
and in column G, it's ('Time ...

**1**

vote

**0**answers

31 views

### Printing multiple Excel tabs as a PDF document

I am trying to get multiple tabs of an Excel document to print as a multi-page PDF document.
I activate the tabs that I want to print, and the print preview is exactly as I want it.
Currently, it ...

**0**

votes

**2**answers

18 views

### Printing multiple sheets with Mail Merge (Excel/Word)

Good morning!
I need to create letters with MS Word, on each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to ...

**0**

votes

**1**answer

25 views

### Change color of row according to column value (by regex)

I'm quite new to excel so this could be dumb question. I need to change color for those rows which has suffix .com in their second column. I use OpenOffice but I can change it using Microsoft Excel ...

**0**

votes

**1**answer

19 views

### Microsoft Excel spreadsheet to JSON?

I would like to create a JSON file from an Microsoft Excel (.xlsx). The sheet has all of the cells a certain height and width. I would like to have the top of each column be titled and used as a key ...

**2**

votes

**1**answer

22 views

### Excel formulas - how to make a cell blank down the page

I am having trouble figuring out the formula for my budget.
Cells look like this
A B C D
DATE WEEKLY BILLS TOTAL
2015 $50 $1,956.73
Jan ...

**0**

votes

**3**answers

33 views

### highlight birthday in a referenced cell

in Excel 2003
in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday
in cell A1 date of Birth
in cell B1 age with the formula:
=DATEDIF($A1,TODAY(),"Y") ...

**0**

votes

**0**answers

14 views

### EXCEL macro opens document but does not ask to “update links”

I have an WORD doc with links to cells in an EXCEL document
If I open the linked document manually, it asks to [Update automatic links] and works perfectly but, when I use the macro
...

**0**

votes

**1**answer

16 views

### Cells evaluated by user-defined module do not update automatically

I read the questions existing but no answer seemed to help. I have a function I wrote in VB which evaluates sum of cells in a certain range by font color, it all works well when I type the function in ...

**0**

votes

**0**answers

22 views

### Excel will not put information in cell? [on hold]

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

**1**

vote

**0**answers

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

**1**

vote

**1**answer

23 views

### How to grep summarized value from excel cell range?

I want to get summarize information from the following sheet. I don't know how to summarize this information.
My scenario is like this.
If I input -6, I want to find my target value in this ...

**-1**

votes

**1**answer

44 views

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

How can I create a formula for the following spread heet?
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 give me total number ...

**0**

votes

**1**answer

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

**-1**

votes

**0**answers

17 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

**0**answers

19 views

### Replacement of a string in excel with another string, taken from a csv file [on hold]

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

**1**answer

21 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

**1**answer

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

**0**

votes

**0**answers

30 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

**2**answers

25 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

**1**answer

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

**0**

votes

**0**answers

28 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

**1**answer

28 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

**1**answer

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

**0**

votes

**0**answers

11 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

**1**answer

28 views

**1**

vote

**4**answers

51 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

**2**answers

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

**0**

votes

**1**answer

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

**3**

votes

**1**answer

24 views

### Match based on String Length

I have data similar to:
My goal to to:
find the longest string in column A
retrieve the value in column B on the same row
so in the above example I want Juliet. If there is more than one cell ...

**4**

votes

**2**answers

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

**0**

votes

**0**answers

29 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

**1**answer

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

**-1**

votes

**2**answers

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

**0**

votes

**2**answers

28 views

### Copying and renaming of .xlsm files using batch

Its glad to be here and i am really excited n new to batch scripting. I have been using a batch containing below for copying an excel from one folder to another
{
@echo off
cp -r ...

**2**

votes

**3**answers

20 views

### Excel SUMPRODUCT - exclude header cells from formula

I have two columns, one with a date and one with values, and I want to sum up all cells, where the year of the date is the desired year. My problem is, that I have headers in the table, and I don't ...

**0**

votes

**1**answer

16 views

### Excel Index Match - How to use iferror / indexmatch

I have a Cell like this
Postcode
2037
2009
2132
2042
2043
2048
2009
2010
Another Tab
2015
2048
2050
2006
2008
2010
2016
I want the result as - if the postcodes in another tab is in postcode - ...

**-1**

votes

**1**answer

21 views

### EXCEL: Can I get a count of a certain value from columns with certain headings, only from the columns with certain text?

A screenshot of the spreadsheet1
Hi
I am looking for a way (in the form of an Excel formula) that can do this
I need to count the number of "o" in columns with headings "Threat", for each row. For ...

**0**

votes

**0**answers

39 views

### Excel Formula to show All dates in a range after today

I am trying to build a spreadsheet that I am using the lookup feature to take data entered on sheet 1 to locate that data on sheet 3, I need it to then list all Dates after today for the current ...

**1**

vote

**1**answer

34 views

### In Excel, is text zero or what?

I have a column of numbers that also contains the letter T. If I use a simple IF(A1>0,..., the letter T is treated as greater than zero and produces the "true" result. However, if I use ...

**0**

votes

**0**answers

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

**2**answers

22 views

### how can I see what TYPE of data is in my macro?

I have the following code that doesn't work inside a macro:
count = Application.Sheets.count
ans = type(count)
msgbox("count is " & ans)
but this doesn't work cause I think type is looking for ...

**1**

vote

**1**answer

20 views

### Excel make a list with a specific conditions

I work in a hospital, have a list of patients, with name, date of admission, date of dismiss, and diagnosis. I need a list with all data when date of dismiss is blank, if contain something must skip ...

**0**

votes

**0**answers

18 views

### Excel autocomplete/ suggestion list. Not a drop down

I am using Excel to record various data and some rows have more cells than others.
How can I make a list of words for Excel to use to autocomplete when I am entering data manually.
I don't need a ...