Questions tagged [excel-365]
265 questions
-1
votes
1 answer
Matching all combinations (values) from matrix-like-table using drop-down
On my workbook (WB) there are 2x sheets. One is Test1 or where I have my drop-downs (from A22 and below) and on A8-A11 are matching fields that are being colored if correspoding match is "hit". In my case FALSE is (_) and TRUE (1) if you are looking…
MmVv
- 553
- 6
- 22
-1
votes
1 answer
How to extract months with data and find n-th value as starting point and n-th value as ending point in Excel Power Query, maybe VBA
I have a data set which consists of Date/Time, Pressure and Custom Column. This represents pressure over time data, where I wanna know my starting point (after 5 minutes) and ending point of -before last value (row) within one month. To help you a…
MmVv
- 553
- 6
- 22
-1
votes
1 answer
Find salesperson with highest sales per client
I have two sheets:
(a) Sales Data
Client
Sales Agent
Value
Apple
Mike Georgi
1,000
Apple
Mike Georgi
2,000
Apple
Michelle Da
4,000
(b) Receivables Data
Client
Sales Agent
Value
Apple
Michelle
7,000
The data on column A &…
Adhurim Uka
- 43
- 7
-1
votes
2 answers
Way to get ranking position in Excel
Name Mathematics Science Biology History Total Marks Rank
A 90 91 95 90 366 1
B 85 95 90 95 365 2
C 98 80 80 85 343 …
Najmul Hossain
- 13
- 2
-1
votes
2 answers
Fast / efficient VBA code to compare two columns in excel for a large database (about 9000 rows)
I am trying to write an efficient and faster VBA code for a mismatched corresponding values, that will:
Check each value of column C against A1:A9000
If found: Copy values of column B and C and paste them against the found cell value (in column B…
Helixeye
- 1
- 1
-1
votes
1 answer
Vlookup/Xlookup (loop?) data from another sheet, then paste as values
Had no luck figuring out how to code this in VBA.
I have a list of names on ws2 starting in cell A5. The size of this list will change daily. I want to vlookup each item from data on ws1. Then would like paste the data as values into corresponding…
Automating_My_Life
- 37
- 5
-1
votes
1 answer
O365 - Providing list of holidays from 2 sources in networkdays function in excel
I am working on a task planner for my team and to derive end date for any task, I would need to pass the public holidays as well the team members planned holidays. Public holidays are available in a table and personal holidays in another.
While…
Yusuf A
- 1
-2
votes
1 answer
What Excel formula can I use to total column H in column L until it caps at 172 showing the amount it used to fix the deficit in last cell?
Column H to total down column L, using the next cell where it comes across a deficit, and populating what amount it used to make up for the deficit in the last cell
I tried this:
=MIN(SUM($H$2:H2), 172)
but it does not use the next column to fix…
L Garcia
- 9
- 1
-2
votes
2 answers
How to made custom Split array function in MS Excel?
How to make a custom made function Split(str as String, delimiter as String ) using Split() in VBA to be used in worksheet.. and it will return as array or SPILL the result..
For example,
Split("{20;30;40;50;60}",";")
will return Spill down Array…
Mr. Tello
- 61
- 5