Latest activity
-
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...
-
Ggarfieldandew replied to the thread [Answered] Fill each Baseball team specific MV values on specific days.I don't think they approve gambling
-
PHi All, Is there a formula/macro that can sum the number of cells in a column, or a range of columns, that are red and those that are...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Glad to hear that the issue is resolved now. You are most welcome.
-
MMaps replied to the thread [Solved] Tax Calculation.Thank you so much Shamima. I am 100% happy now. My query has been solved.