Latest activity
-
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.
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Try this formula there: =MIN(D17*5%,215*((YEAR($C$23)-YEAR($C$31))*12+MONTH($C$23)-MONTH($C$31)+1)) For your spreadsheet...
-
shamimarita replied to the thread [Solved] Nested If function not working.Hello TrevorWestbrook, Thanks for your feedback. Keep contributing on the ExcelDemy forum to help each other.
-
MMaps replied to the thread [Solved] Tax Calculation.Hello Shamima. Once again, thank you for your patience on my query. I however, still cannot get the tax deductible year to date from...
-
Sstrsbtitest updated their status.strsbtitest
-
TTrevorWestbrook replied to the thread [Solved] Nested If function not working.Good explanation - the early TRUE short-circuit is what trips most people up with nested IFs. The LOOKUP approach is definitely cleaner...