excel-formula Questions
6
Solved
I would like to aggregate, merge, compact some values as shown below
The input is a table and the output is dynamic array formulas on a single Cell and has a goal to aggregate other columns based o...
Petula asked 14/9 at 15:51
5
I am using the new dynamic array functions introduced in Excel in 2018 (e.g. SEQUENCE, UNIQUE etc. functions).
I have a list of cell references that are generated dynamically and would like to appl...
Hawse asked 23/10, 2020 at 19:4
2
Solved
How can I reference a cell in the same column in the previous visible row from a filtered range?
Commodus asked 12/3, 2015 at 18:2
2
Solved
I've got a column of ages and a column of the count of those ages. I need these to be transformed into a set that I can run statistical functions like average on. For example:
Age
Count
14
...
Kovno asked 20/10, 2023 at 15:21
6
I'm trying to generate a random 8 character alphanumeric string in Excel (or Google Sheets or Libreoffice, which both have the same challenge) using a formula. I'd like to get something like this:
...
Prae asked 5/12, 2022 at 21:57
7
Solved
Without VBA, I am trying to refer a range that starts at A2 and never ends. For example, if I want row 2 till row 5 i'd do
$A$2:$A$5
But what if I want the end to be open?
$A$2:??
Is this po...
Aemia asked 6/10, 2017 at 8:56
6
I am trying to check a table for specific data and if i found the data it will display the data. I did that with VLOOKUP. But now if the data is not in the table i want to interpolate between two s...
Gauthier asked 18/3, 2017 at 16:58
1
Solved
I have a series of values in Excel.
The top row is a base number. The second row is how many values in each number in the series. The third row is the total value of that number in the series.
Not...
Biotin asked 4/6 at 11:8
14
Solved
I've got a massive Excel 2003 spreadsheet I'm working on. There are a lot of very large formulas with a lot of cell references. Here's a simple example.
='Sheet'!AC69+'Sheet'!AC52+'Sheet'!AC53)*$D...
Macneil asked 12/7, 2011 at 17:25
5
Solved
I'm having a hard time figuring this one out.
I have a short list of numbers in column C (C4 to C19).
Those numbers can range from 0 to anything. Never empty.
In column D is a date, in column E is ...
Hibbs asked 16/4 at 14:29
4
Solved
I would like to generate 5 random number between 1 and 49 and place them into a row range like A1:AA1 in 5 random positions. The empty cells should get a value of 0.
The basic concept is =RANDARRAY...
Liberia asked 16/5 at 12:37
7
Solved
I would like to apply a Filter function on multiple columns ranging from A:G and only have columns B,D in the output. How can I do it?
For Example =FILTER($A$1:$G$7,$K$1:$K$7=$K$1) results in a spi...
Carboxylase asked 14/10, 2021 at 20:47
5
I'm really struggling to find an answer to this as online I've really only found VBA solutions to this problem which isn't what I wish to learn how to do.
THE PROBLEM
BLOOD NAME AGE GENDER
A Davi...
Crescent asked 8/4, 2016 at 17:50
7
Solved
I'm looking for a way to compute a random number once in Excel. So its computed the first time its called, but then it doesn't change afterwards.
So for example, if I had something like this in B1...
Ding asked 4/11, 2011 at 14:46
5
Solved
With data in A1 - B5:
A 1 //remove
A 2
B 3 //remove
B 2
C 1
How do you remove duplicates in column A, keeping the last set of values in other columns? Results should look like this:
A 2
B 2
C 1
I...
Flighty asked 25/4 at 20:14
6
Solved
I'm designing a set of related excel file which are related between them. The objective is that the macros which refere to each other document, can work in any given computer/path. For this reason ...
Unclothe asked 25/7, 2019 at 9:29
3
Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected. Even after closing the file
While protecting formulas with standard code like this:
Sub TestMe
dim myCell as range
with Worksheets(1)
For Each myCell In .Range("A1:R102").Cells
If myCell.MergeArea.Cells.Count ...
Thorncombe asked 22/1, 2021 at 15:5
3
Solved
I tried char(10) and char(13) but they don`t work by me. I use Excel 2007 and my task is to replace new lines with intervals
Asdic asked 18/12, 2015 at 16:11
15
Solved
I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows:
Column A Column B
a a
a b
b c
c
c
This Column B...
Stomacher asked 9/11, 2012 at 12:16
3
Solved
I am using the XIRR formula as follows:
=XIRR(E$11:E17,B$11:B17)
but need to add an additional non-adjacent cell to the Range of values and dates.
My first attempt:
=XIRR((E$11:E17,H17),(B$11...
Chara asked 4/1, 2014 at 21:4
4
Solved
Is there any way to not change the formatting of the column when pasting a value into the column?
I've found a ton of workarounds that are "after the fact"-fixes. Ones where you paste it in, for...
Uvea asked 3/1, 2017 at 12:51
3
I have an excel with 28 position binary numbers. I need to convert them to decimal numbers, but function bin2dec don't work with numbers longer than 10 bits. Can anyone help me with this?
Jinnyjinrikisha asked 29/2, 2016 at 6:13
3
Solved
I have the following data in Excel:
The real data will go on for over 100 columns.
What I want to get is a sum of the number if it were to repeat horizontally by the number of repeats. NB: Technic...
Sherl asked 9/3 at 6:53
2
Solved
At risk of being off-topic I decided to do a little Q&A as I'm pretty excited about a new function MS is introducing to Excel365; the LAMBDA() function. If the general opinion is such that this...
Marleen asked 18/12, 2020 at 22:46
4
Solved
I have some data that looks somewhat like this:
Alice
Bob
Carla
Dave
Role
Role1
Role1
Role2
*Role2(
Jan
Activity1
Activity2
Activity3
Activity1
Feb
Activity2
Activity1
Activity1
Activi...
Avner asked 3/6, 2021 at 15:1
1 Next >
© 2022 - 2024 — McMap. All rights reserved.