Latest activity
-
SprintzealT updated their status.Sprintzeal’s ISO/IEC 27001 Lead Auditor Certification Training in Bahrain is designed for professionals who want to develop practical... -
TTouristTravelGuides updated their status.Your Gateway to Smarter Travel Experiences Welcome to Tourist Travel Guides. Here, people who love to travel get helpful ideas about...
-
shamimarita replied to the thread Number of text cells by color.Hello PomDave, Let us know your feedback and solution. -
PPomDave replied to the thread Number of text cells by color.Sorry I haven't replied earlier, personal issues. Thanks for that I'll give it a try. Rgds, Dave R.
-
shamimarita replied to the thread How can I return the latest value based on a matching ID?.Hello Marktuan, In Excel 365, a simple and efficient way is to combine XLOOKUP with MAXIFS. Assuming your data is in A2 (ID, Date...
-
shamimarita replied to the thread Moving duplicate date data to another column.Hello AprilLynnRN, Thank you so much for the kind words. Glad to hear it worked! The spill error is expected here. Excel Tables do not...
-
AAprilLynnRN replied to the thread Moving duplicate date data to another column.I copied the data values instead of the formula and it worked. I would love to just be able to update that one original table and put...
-
AAprilLynnRN replied to the thread Moving duplicate date data to another column.You are my hero! Where have you been all my life? Thank so much, this did work. I knew there had to be an easier way. The only issue...
-
Mmarktuan posted the thread How can I return the latest value based on a matching ID? in Excel Formulas.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...
-
shamimarita replied to the thread Moving duplicate date data to another column.Hello AprilLynnRN, Since you're using Excel 365, I think you're actually very close to a formula-only solution and may not need Power...
-
AHello everyone, I've been using AI and searches to no avail. I want to create an "Event" Table for all intents and purposes so that it...
-
shamimarita replied to the thread Number of text cells by color.Hello PomDave, Yes, this is possible with a small VBA user-defined function. Excel formulas cannot directly count cells by font color...
