eee

Hi, I have a set of data like this <tbody> AAA 2-May-20 BBB 18-Jun-20 CCC 29-Mar-20 DDD 9-Feb-21 EEE 9-Feb-22 FFF 9-Feb-20 GGG 9-Feb-23 HHH 9-Feb-20 JJJ 27-Feb-28 KKK 2-Jan-27 MMM 14-Oct-21 NNN 15-Oct-19 </tbody> I want to sort it like this <tbody> Before 2020 Between...

Print rows as cols without repeats <ins id="aswift_2_expand" data-ad-slot="9830241510" style="text-decoration-line: none; display: inline-table; border: none; height: 250px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 300px; background-color: transparent;"><ins...

I've hunted for some help in the forum, but I cannot find what I'm looking for or get it to work in Excel 2013. I think some of the threads on Index and Match are the way I should go, but I cannot get it to work. Basically I have a value on sheet1, and I want to find the first occurrence of it...

Data as below <tbody> Parent Child AAA BBB BBB CCC AAA DDD DDD EEE EEE FFF CCC GGG GGG HHH HHH III III JJJ III KKK JJJ LLL KKK MMM MMM NNN </tbody> and continues. Output should be collapsed. EX. as below <tbody> AAA + BBB + CCC + GGG...

Hello everybody. I've a situation like this: I've to find the string in cell A2 ("C57") in column F (the recurrences could be 0 or 1), and then copy the values INFO 1, INFO 2 and INFO 3. In this case: B2 EEE C2 CCC D2 AAA https://imgur.com/a/IW3vL I've tried with INSTRING and VLOOKUP, but...

Does anybody have any suggestions on how to create a conditional rule that finds non-consecutive duplicates in a column of data (numbers or text)? For example, the data below have been highlighted (red text) showing the desired result. Note that all occurrences need to be formatted. AB AB AB...