Questions about using in-cell functions/formulas in spreadsheet software.

**1**

vote

**3**answers

84 views

### How to generate a list of the possible combinations of N dice in Excel

I want to list the possible combinations of 2,3,4,5,6,etc dice.
For example:
For 2 dice, cell A1 is 11 (1&1). I would like to drag the cell down to automatically add the following 2-dice ...

**0**

votes

**1**answer

41 views

### Importing data to Excel does not calculate formulas

I have now read about 40 tips on this subject and it does not appear anybody has a solution other than "click inside the cell and hit enter".
I have to create many spreadsheets with thousands of ...

**0**

votes

**0**answers

31 views

### Excel - Can I create a list of values with criteria and have excel make a list with parameters?

In Excel, I am trying to see how many combinations I can make with the allotted criteria and such.
So lets say I want to know how many combinations of groceries I want to buy for a certain budget. ...

**2**

votes

**4**answers

40 views

### Error subtracting times

I am trying to subtract a PM time and AM in Excel 2013. I am getting the ##### error.
Example:
A1=7:00 PM B2=12:30 AM
=+A1-B2
I have the cell formatted in time, but it comes back with the ...

**0**

votes

**0**answers

16 views

### How do I find how many times two rows share a value across multiple columns in Excel?

I have a table, something like this:
Example A
Where I have a list of zip codes down column A and then another 50 or so columns (ex: A-D) that contain values. The value is entered in each cell ...

**0**

votes

**0**answers

22 views

### Excel dynamic range selection and look up

There is a list of unique identifiers. The list is dynamic (one day it has 7 and another day it has 17).
Based on this list, we download data related to those identifiers in another sheet.
This ...

**0**

votes

**1**answer

26 views

### In Excel, input values of one column based on value of another

I currently have ten sheets representing ten years of data. In the sheets I have rows representing objects in images, with an attribute corresponding to the image the object is located in. The image ...

**0**

votes

**1**answer

19 views

### Excel LEFT and IF

Mostly all fields begin with the name and address, but some fields start with a number. I would like to have the address removed leaving only the full name, which I do have the formula and it works ...

**1**

vote

**1**answer

30 views

### How to “merge” multiple rows in one column while keeping the rest of rows separate? Excel 2010

I have several rows with different data. One of my columns is for names. How can I merge the cells with the same name, so there is only one cell with the name up front, and several rows with the ...

**1**

vote

**3**answers

141 views

### Counting occurrences of a value, two columns

I want to count the occurrences of values >=13.8 in two columns, no problem with that - but if both of the values on the same row is >=13.8 I want it to count as one match.
Here's an example
...

**0**

votes

**0**answers

18 views

### Listbox, mouse wheel scroll issue

Whenever I try scrolling through list Box created by Excel Vba , using mouse wheel . Excel sheet tend to freeze up .
have any one experienced the same ?
Excel version that I am using is 2007.

**0**

votes

**2**answers

36 views

### How can I add all previous cells to a cell using a function in Microsoft Excel?

If I have a column:
0 |
1 |
2 |
3 |
4 |
I would like for in the column on the right to take a cell on the left and add all previous cells to it. So that it looks like the two columns ...

**0**

votes

**0**answers

35 views

### Excel Highlight cells with matching text when hovering over cell

I have an excel sheet showing a College course progression, When I hover over a cell with a class name in them, I want cells matching the names of the dependent classes to be highlighted, what's going ...

**0**

votes

**0**answers

7 views

### Why is my default templet (xlstart/book or /sheet) not used when I import data

Why is my default template (xlstart/book or /sheet) not used when I import data.
I set the default workbook to format the first column as text, or as a custom format (seventeen zeros) but when I ...

**0**

votes

**1**answer

60 views

### EXCEL: How to Search multiple files for value corresponding to text in same row?

I know this is a blatant help me post, but I have been given this task and I don't know how to get it done in time.
I have moderate knowledge of excel, but I dont know any VBA. I have learnt C++ so ...

**0**

votes

**0**answers

11 views

### Excel Adding comments from current worksheet to new imported data that has changed

I import data daily, format it, add notes in multiple columns, and save this. The next day, a new import is run (data will have changed), formatted and saved under a new name. I need to get the ...

**0**

votes

**4**answers

78 views

### Excel - how to drag down formula while keeping horizontal cell reference continuity

I been trying few formulas and google search, but wasn't able to find anything that would help my problem. To keep it simple, as explained in the attached picture, how do I drag down formula ...

**0**

votes

**2**answers

31 views

### How to keep a columns formula applied to a newly added row?

I have a recurring formula down an entire column but every time I add a row the formula isn't applied to those new cells in that column. How can I make the formula permanent so it is consistently ...

**3**

votes

**1**answer

18 views

### Formatting number within text

I have the following formula
=concatenate("Price is ", A1," of new price")
where the value "A1" is the percentage value.
What should I write in the formula so the percentage value of A1 appears as ...

**0**

votes

**1**answer

24 views

### Excel get the range of Cells beneath a cell that match criteria

0. A, B, C
1. Level, Name, Std Dev
2. -1, Total, 88.80
3. 0, Commodity, 367.31
4. 1, Option, 582.81
5. 2, DBA, 582.81
...

**2**

votes

**1**answer

31 views

### Combining OR with AND in Excel

I'm trying to write a formula in Excel 2016 which outputs a "Yes" if the following two conditions are met:
A2 value begins with 4 OR 9
A2 value length is 8
Otherwise output "No".
This is the ...

**3**

votes

**1**answer

38 views

### IF formula in Excel to calculate various outputs, defined by days between 2 dates

I'm trying to write an IF formula to calculate 4 types of data based on 2 dates.
Example:
Cell I4 (Install Start)
Data entered here, eg 20/10/2015
Cell J4 (Install End)
Date entered here, eg ...

**1**

vote

**1**answer

65 views

### How to count number of cells over multiple worksheets whose values are in between a given range?

I have an Excel workbook with numerous worksheets containing data like:
'DATA_1' 'DATA_2' 'DATA_3'
A B A ...

**0**

votes

**1**answer

20 views

### Excel Lookup for work sheet comparison

I have 3 sheets. The first one contains data for Shop A, the second data for Shop B, and the last sheet contains the results.
Sheet A & B: Item Code, Name, Brand,and Stock
I want to compare ...

**2**

votes

**1**answer

31 views

### How to make Excel increment by a large number (I want the values of cells D4,D100,D196,D292, etc)

I have ~35000 data points, and I want to sum data points 4-99,100-195,196-291, etc. So basically I want 365 sums of 96 data points each.
I managed to use the IF function logic to print the sums I ...

**1**

vote

**1**answer

36 views

### How to simplify Excel/Google Sheets formula with redundant method calls?

I have an Excel (Well, technically Google Sheets) workbook containing product inventory warehouse storage information. I figured out how to construct queries so it grabs the needed information from ...

**0**

votes

**1**answer

23 views

### Excel, Lookup output colum depending on another cell

I currently have lookup function that takes a code, looks for it on a specific column and gives me a price value on a specific column based on the code. I use this function many times, for different ...

**1**

vote

**1**answer

33 views

### Repeating values - Microsoft Excel [closed]

I am provided a large spreadsheet monthly that requires up to 6 instances of the same customer ID to be entered manually. I would like to design a Macro or VBA code that will take my customer list and ...

**0**

votes

**2**answers

16 views

### Trying to put in values or leave the cell blank

I'm trying to put in a formula that puts the cell at yes, no or blank. I tried the following, but received errors:
=IF((I5<=J5),"Y","N"),OR(ISBLANK(J5),ISBLANK(K9))
I can get the yes/no ...

**0**

votes

**1**answer

58 views

### how to generate serial number for each selection in combobox in excel vba

Private Sub CommandButton1_Click()
With ComboBox1.Value
Dim a, b As String
Dim i, j, k, l, x, q, m, temp As Long
a = ComboBox1.Text
i = ...

**2**

votes

**4**answers

257 views

### Is there any formula which should insert time which should not auto update in the excel sheet?

I want to know is there any formula except =NOW() to insert time in an excel sheet also which should not update time automatically?
The formula =NOW() is working fine but the problem is that it is ...

**0**

votes

**1**answer

40 views

### How to insert Time in a range of excel sheet which should not update automatically?

Friends I want to insert time in a range which should not get updated automatically. For example if there is any value in cell no k5 then the current time should automatically be inserted in cell no ...

**0**

votes

**1**answer

21 views

### creating a functional array to store names of files in a folder

i want to create a functional array that stores all name of file in perticular folder
this is what i tried..
Function number_of_file(i As Integer) As Variant
Dim file_object As Object
Dim ...

**0**

votes

**0**answers

21 views

### Rounding up from a list of values / Returning a value from a table in Excel

I have already worked out 1 variable in a Spreadsheet (In this case it's the "AREA OF STEEL REINFORCEMENT") but it needs rounding up to a specific value given in a table.
Firstly though an input ...

**0**

votes

**1**answer

44 views

### How do I delete repeated values (#Not remove duplicate values#) in a column excel?

I have the following two columns of data:
Location Value
A 1
A 1
B 2
C 2
D 3
D 3
E 4
E 4
F ...

**0**

votes

**1**answer

26 views

### Split Excel Cell by last Delimiter and get Text to left

I need to split a cell by the first delimter (reading right to left) so that I can put that value in another cell.
For Example, my data in cell A1 could look like:
"something - more something - a ...

**3**

votes

**1**answer

36 views

### I need an elegant way to decode a series of codes into a single Excel cell

We have a cell that's filled with up to five comma delimited two letter codes. There are 20 possible codes. I would like to create a single cell that contains a "decode" of those two letter codes. ...

**0**

votes

**1**answer

24 views

### Changing formula fill step

I'm trying to make a formula from one sheet (Sheet 2) which calculates the minimum value of a given block of cells in another (Sheet 1). The block is of consistent size.
When I drag the formula down ...

**0**

votes

**3**answers

71 views

### How can I get the unique values present in a column for each set of identical values in another column?

I have the following two columns:
Con.By Prod
A 1
A 1
A 2
A 2
B 1
B 1
B 2
B 2
I can easily get the unique values either in column Con.By or ...

**1**

vote

**3**answers

120 views

### How can I compare what data value changed over two periods?

For my Fantasy Football League I'd like to quickly be able to compare the data of two data sets to see who moved up/down the table over a week period (two different sets of data).
Here's an example ...

**1**

vote

**1**answer

38 views

### Spreadsheet formula to display most recent prices

I have created a LibreOffice Calc spreadsheet with columns A-C. In column A, I have a list of parts purchased (in chronologically ascending order). In column B, I have a list of corresponding ...

**1**

vote

**1**answer

27 views

### Grouping sums in Excel [duplicate]

I'm currently doing dissertation work which requires me to average 95 pieces of tidal data for a month. I have all my data, but averaging them is turning out to be a tedious pain.
I have 95 points I ...

**0**

votes

**2**answers

42 views

### How to do an Except filter in Excel as a set operation?

Say I have two sets:
1
2
3
4
5
6
and
3
6
I want to be able to get the first one except the second, e.g. 1
2
4
5.
How could I do that?

**0**

votes

**1**answer

41 views

### Show/hide a certain number of Excel rows based on cell value

I'm creating a loan repayment calculator schedule with Excel 2010, where the user inputs loan amount, interest rate and duration (in months), and the calculator returns the repayment value for each ...

**0**

votes

**2**answers

40 views

### Excel: evaluating “January < now()” fails

A friend is supposed to receive $75/month from his clients.
He would like an Excel sheet, which would allow him to enter how much each client paid him during the month, and to calculate their ...

**-1**

votes

**1**answer

31 views

### Need help to find a solution for excel spreadsheet 2010

Example:
Column A Column B Column C Column D Column E
Maricar Gener Adriel 3 (It's like an auto sum)
Jocelyn Gener ...

**0**

votes

**1**answer

27 views

### Linking rows in Excel without merging

I would like to know if it is possible to link rows together in Excel without merging. For example, I would like A1 tied to B1 so when I move A1 around to different positions in Column A, B1 will ...

**0**

votes

**1**answer

42 views

### Pop Up Message On Excel Cell

I would like to have a pop-up message to remind the user to proceed to section iii to complete the rest of the input.
I attempt to use Data Validation>Input Message but the message is always ...

**-4**

votes

**1**answer

40 views

### Why am I getting a #Value error with my IF statement?

I keep getting an #VALUE error with my IF statement in Excel. Any ideas why? Any help is greatly appreciated!
=IF(
OR(
R2 > 3
),
0,
( IF(
R2 = 1,
...

**2**

votes

**3**answers

54 views

### How do you properly align average and standard deviation outputs in a spreadsheet?

I am not sure of the best way of formulating this question right now so I will use an example using random numbers. I start with values assigned to IDs, so that each ID can be n=1, n=2, ... etc
ID ...