Latest activity
-
PPinacolada1974 replied to the thread [Solved] Pivot table - Refresh Data.I have excel sheet created in my office desktop
-
PPinacolada1974 replied to the thread [Answered] Get Data from Password protected PDf - Bank Statement.You have mentioned a complicated and critical method.
-
Acnologia replied to the thread How can I return the latest value based on a matching ID?.Hi there! Since you are using Excel 365, you have access to some powerful dynamic array functions that make this very easy. The best... -
Acnologia reacted to marktuan's post in the thread How can I return the latest value based on a matching ID? with
Like.
Hi everyone, I have a table with multiple entries for the same ID and different dates. I would like to return the most recent value... -
PPinacolada1974 replied to the thread [Solved] Pivot table data link to another tab in same sheet.Hi
-
PPinacolada1974 replied to the thread [Solved] I desperately need help on how to create excels for each of these problem. Could someone please help me!!! Please I need help!.Shamima Sultana
-
Bblagodeveloper updated their status.Двокімнатна квартира — це комфортний вибір для сім'ї, пари чи тих, хто цінує додатковий простір. Якщо ви плануєте купити дешево...
-
Ddavidbaggins replied to the thread How can I return the latest value based on a matching ID?.If you're using Excel 365, you can do it with a single formula using `XLOOKUP` and `MAXIFS`...
-
Ddavidbaggins replied to the thread Number of text cells by color.You can use a simple VBA user-defined function: Function CountFontColor(rng As Range, sample As Range) As Long Dim c As Range...
-
Bbenx01 replied to the thread Advance Filter using Macro or VBA.Lucas, Actually, the implementation of the AdvancedFilter feature in the VBA code will definitely resolve your problem. The main...
-
SprintzealT updated their status.Sprintzeal’s ISO/IEC 27001 Lead Auditor Certification Training in Bahrain is designed for professionals who want to develop practical...
