Questions tagged [excel-365]
265 questions
2
votes
1 answer
I want to find multiple output based of 2 given conditions in excel?
I have a dummy data for origin and destination, I want to find list of cities as text which are 4 hrs. of destination. It should give me a list of cities when I change the origin. Can this be done easily by doing some lookup and match function?
Jogi Singh
- 49
- 9
2
votes
2 answers
How to get the row value to map with column using Excel?
As part of my learning to work with excel, I got stuck in two places:
1 - Get to reference the row values in the column.
2 - Is there a better way to calculate the sequence.
Formula Used:
for 1st sequence
=SEQUENCE(A2, 1, 1,1)
for remaining…
John Smith
- 1,095
- 2
- 11
- 24
2
votes
2 answers
How to convert big numbers between HEX and DEC in Excel without using VBA?
The Excel-Functions =HEXTODEC(hex) and =DECTOHEX(dec) work fine but only up to a value for hex of 0x7F FF FF FF FF. I need to convert numbers up to 0xFF FF FF FF FF. Beginning with 0x80 00 00 00 00 Excel sadly starts interpreting is as a signed…
switches
- 25
- 4
2
votes
6 answers
Excel FILTER() returning 0 for blank cells
I suspect this has been asked previously, but I can't find it.
FILTER() will often return a 0 for blank rows, even when a return string is specified.
Using filter() I am often getting a 0 return value for empty cells. Assume these 6 rows of data in…
David Richardson
- 123
- 1
- 1
- 8
2
votes
1 answer
Delete Power Query steps after loading to Power Pivot data model
I need to delete query steps after loading the data into model. The reason is to hide the sources, protect our know-how, or maybe I'm just not very proud of what I've done ;).
But when I delete PQ connections or change "Load To" option, also the…
AdamL
- 12,421
- 5
- 50
- 74
1
vote
3 answers
Textjoin with Filter Down a Column
Textjoin and filter by values down a column, not in one cell.
I want to join on one row per each unique value in column N on the other sheet. Here is an example of my input data on the other sheet (Sheet2):
Column A (Version), Column N (Value)
1.1 …
RSC001
- 13
- 2
1
vote
1 answer
Need Help to find an excel formula
I have some data in Column A such as 1-2-3-0-5-2-1 and in column "B" A-F-E-G-C-B-D now I want to sort column A and B's Data based on Column A's Value then what will be the formula if I want to rearrange them in another two cells. I got a formula to…
Alauddiin
- 25
- 4
1
vote
1 answer
Split data in 1 column while retaining data in other columns
I have data that comes in to me daily that I am manually separating column B (Node Area) into individual rows. I am looking for help creating a solution that will retain the rest of data in the row and split out Column B by carriage return.
I have…
Kavorka
- 306
- 3
- 10
1
vote
1 answer
Using the SeriesCollection.Extend method
I would like to use SeriesCollection.Extend method to extend the range of a chart.
Worksheet(1) has the values
Column A
Column B
DATE
6/1/2023
1
6/2/2023
4
6/3/2023
6/4/2023
The first 3 rows/columns are charted as "Chart 1".
I…
oldsilenus
- 11
- 2
1
vote
1 answer
Remove double values and sum the values
I'm trying to remove the double values of the first column and make the sum of the values in the others column for this double.
I'm using dynamics arrays of Excel 365 (In French), I will try to translate correctly the formula.
So I have this data…
MonkeyJLuffy
- 195
- 3
- 15
1
vote
1 answer
How to restore RibbonUI if two files open simultaneously?
I have below code to restore RibbonUI where RibbonUI randomly lost its value aka it becomes nothing. This code works well if the file which contains this code open in single. But if I open the copy of this file then the excel crashes/closes in the…
Dhay
- 585
- 7
- 29
1
vote
1 answer
Excel Attendance Sheet repeat friday twice
I have made an attendance sheet.
My excel sheet contains following formula in cell H7
=DATE(E5,@INDEX({1,2,3,4,5,6,7,8,9,10,11,12},MATCH(D5,monthNames,0)),1)
Where cell D5 contains Month Name and E5 contains Month Year
In cell H6 contains following…
Atif
- 13
- 2
1
vote
0 answers
Excel 365 Power Query: 'Data from picture' is the only option available, how can I access 'From table/range'?
I'm trying to load my data into power query on excel 365, but on my data tab, the only option available is 'Data from picture'. I'm trying to access 'From table/range'.
Please help
I also went to File>Options hoping to be able to see COM.addins and…
Glory Aderinwale
- 11
- 1
1
vote
1 answer
How to do Gap analysis in Excel
I have below data format in excel:
I would like to perform a gap analysis which must automatic show the 'gap' filled as below.
I tried this formula: =RIGHT(J35,1)-RIGHT(K35,1)
But, I'm getting which says #VALUE!
EDIT: I'm trying it in this way.
…
AskMe
- 2,495
- 8
- 49
- 102
1
vote
1 answer
Excel--Let & Lambda, dynamic array count of instances
The following formula produces a list of results in a single cell as expected.
=BYROW(FILTER(M4#,{1,0}),
LAMBDA(a,
LET(
varARR,…
RandyB
- 15
- 6