Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
Greater than expression using dynamic filters
Post Flair (click to view more posts with a particular flair)
Post Body

Hi /r/excel!

I hope you guys can be of assistance, and please excuse my ignorance. It has been quite a while since the last time I've used excel, especially anything more than entry level material.

What I'm trying to create is a database of RV inventory for the company I work for. I need to filter the database of RVs and filter them by many specifications such as Class, Slides, Length, Weight, etc.

So far, I've watched a Youtube video on dynamic filtering and have been able to filter out my data into another table. I've also been able to take the data, and filter that onto ANOTHER table.

Both of the filters I've created so far are the classes (Either class A, B or C) and floorplan (Rear Living, Front Living) which has been relatively easy. I'm not sure how poorly optimized this is but it's not my biggest concern right now.

My PROBLEM. I am trying to filter the 2nd table I made to filter by the amount of slides an RV has. Now, this is difficult because I am basically searching for 1 or more slides, 2 or more slides, 3 or more slides. But I'm not sure how to express this with the formulas I'm already using.

I don't necessarily WANT to filter my data one at a time, but I'm learning so this is the only way I know how. If anyone has any resources to point me in the right direction I would be VERY thankful.

Not sure if I'm allowed to post a download link to my file but here she is: https://docdro.id/wqDzLaB

Upon further inspection, it doesn't even look like my second search box is working correctly...

edit: also, if someone knows of a more user-friendly application to accomplish what I need, I will love you forever.

Author
Account Strength
100%
Account Age
11 years
Verified Email
Yes
Verified Flair
No
Total Karma
11,566
Link Karma
925
Comment Karma
10,277
Profile updated: 3 days ago
Posts updated: 9 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
5 years ago