•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Having issues counting unique instances of pick up and drop off locations based on if money is in the same row.
Our take
If you're facing challenges counting unique pickup and drop-off locations based on monetary values in your dataset, you're not alone. With approximately 62,000 rows, organizing this information can be daunting. Your goal of referencing origin locations to count distinct instances where money is present is achievable. While you've explored functions like ROW, UNIQUE, and FILTER, a streamlined approach may be necessary. Let’s delve into potential solutions that can simplify this process, making your summary tab both efficient and insightful. Your data deserves clarity!
I have a contract I'm working on for work so I will give what I can to see if someone can help. We have roughly 62k rows of information. It is a combination of pickup and dropoff locations. There are 9 pickup locations with various dropoff locations. Each pickup and dropoff are repeated 3 times based on another column. What I am looking to do is on a summary tab I want it to reference the origin location go to the full data sheet and count each row that has that origin with money and count only the first time the pickup and drop off location appears. I'm not sure if this is possible or if I just need to manually counting. For reference I've tried a combination of ROW, UNIQUE, and FILTER with various COUNTIFS or IF statements but nothing has worked. Even resorted to asking AI but either my prompts aren't correct or it just doesn't understand. Thanks in advance for any advice or tips to try!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Returning multiple matches per ID (auto-fill when dragged down?)Hi there! I have multiple assigned IDs for a single code so I need to return all matching values, not just one. I also want this to be kind of automated (?) when I drag down the upstream ID column, it can pull all corresponding values, even if they share or don't share the same code I tried using FILTER, but it only spills results in one place and doesn’t carry over properly when dragged down for other rows. I don’t want to adjust ranges every time manually since my data might get longer. Is there a way to make a formula that: works when dragged down, returns multiple matches per ID, and still updates properly even if the data goes beyond the current rows? Left Side = source workbook; Right Side = destinatioon workbook Thank you so much in advance! submitted by /u/jeankrstein [link] [comments]
- How do I organize this data properly?I must preface this post with the fact that I am an amateur using excel. Im trying to learn, but I still dont know what I dont know. I am manually creating a spreadsheet that tracks certain things that are important to me in regard to my crew. I am a fire captain and I am surprised that the 'insights' of the software we use to document emergency responses does not track specific units chute times. It only calculates the first unit that responds chute time. Most of the time we will have 2-3 units respond on calls, I want to know the chute times of each unit. I also want to know how frequently we go to certain addresses and the types of calls we go on. Where I need help is I have multiple rows in my data table that refer to the same call because of the different units that respond. I dont know how to count unique case numbers or the amount of times we went to an address with different case numbers. See the screenshot, I hope I am explaining correctly. I am open to feedback on arranging this data differently to make more sense. Just a snippet of the data submitted by /u/jham5426 [link] [comments]
- Get rid of duplicates in several columns based on a unique value in one column?EDIT: Thanks for all the suggestions! I like the one I marked as verified because it's very simple and something I can easily teach to coworkers. I manage a private Wordpress-based web store. We invoice the client each month based on a spreadsheet export from Wordpress. It's necessary for this export to have a row per line item, which means we get duplicates of all the other order data, like shipping cost, order subtotal, and order total. We need the sums of those mentioned columns, so we end up manually deleting all the duplicates to do an =SUM at the bottom.... It's time consuming and prone to error, given that a monthly invoice has anywhere between 800 to 1500 line items. I've searched up similar solutions that can formulaically delete duplicates after the first unique value, but I don't think that would work here because there could be the same values across different orders. How can I do this using the order numbers, since those are unique? Example attached. Note that several orders have the same shipping cost. https://preview.redd.it/0jfht5w4ejyg1.png?width=460&format=png&auto=webp&s=bc237e320069cc78e73e3525253575af4f92e10a This is what I want the result to be. https://preview.redd.it/qf2gafp5ejyg1.png?width=460&format=png&auto=webp&s=9d6fb08df35a80c5e802c03b88be0b8e754b1e22 Is this possible, or has anyone got any ideas for how to gather these sums a different way? submitted by /u/rehaharbor [link] [comments]
- Help locating specific data from rangeHello all, I was wondering if someone could assisst me. Im still learning excel and having some success, but currently im struggling with a problem. I have a bunch of data across multiple cells. Some columns would have time stamps, location, error codes, vehicle numbers etc. Lets say i have a bunch of data for all vehicles and errors. How would i go about automatically filtering through the data looking for, example, error code 515. Ideally have an entire sheet that shows all data but just for a specific error code. Or a name. I appreciate any help on the matter. Even if you point me in the direction of useful information, videos etc. Id be very grateful. Thank you submitted by /u/liveactiongeek [link] [comments]