albert

I have an excel where in D column Same name are appearing multiple times. They are already grouped I just need to provide unique_id code (1, 2, 3...) for each group as shown in below example in column E: Col A Col B Col C Col D Col E...

Hi all. I am trying to filter the number of say invoices pending and the formula bellow does this. =COUNTIF(E:E,"NO") However, the goal here is to show only the number of customers with outstanding unpaid invoices. These would be marked on say collumn E as NO. So, say column D has customers...

Is there a formulaic way to turn a list in two columns like this: <tbody> Albert 3 Bob 2 Charles 4 </tbody> into a new list in a single column like this (where the number of times that a name appears is dynamic based on the number next to it in the original data like above): Albert...

Hi all, I'm trying to figure out how to get the names of the Top 3 highest values without duplicating names, but allowing duplicate values. I have a list of (often repeating) names in table column [Last, First]. I have a single value relating to each name in table column [Used]. I have...

<tbody> A B C D E F 1 Store # Store Name Date Due Completed By Owner 2 1234 Abby 5/12 John Albert 3 5467 Cothes 8/12 Pete Albert 4 3452 Main 9/3 Steve Jeff 5 3553 Ramsy 10/8 Albert 6 5324 Corner 11/8 Jeff </tbody> Hi All, I have a tracker set up which tracks...

Hi Guys. I want to use sumproduct to add for me a non continuous range. For example, for the name Albert, I would like to add the sales from Jan thru March and then from June thru Aug. A B C D E F G H I Name Jan Feb Mar Apr May Jun Jul...