Lookup in a range of cells and extracting cells based on values and criteria

**A_W** · 11-02-2016, 07:31 AM

Hi there,

Please be gentle with me, I am no Excel guru hence to request to you guys for higher power...

Basically I want to list the instances where I have a user-name in column C = BHE (for example) and then the row with a value of Acct-Input-Octets in column C has a value greater than 4000. I need to find all instances of these occurrences, and ideally add then together as well.

The complexity of this is that I have a number of rows with a timestamp and I have look within all those rows with a common timestamp as my Acct-Input-Octects and the username are on different rows.

Hopefully the fields I created within the attachment make my explanation make more sense..

I dont even know if it's possible, but hopefully it is - took me the whole day yesterday to do it manually and I've lost the will to live to do it again next month..

Hope you guys can help.

Regards
Andrew

**Olly** · 11-02-2016, 08:06 AM

If I have understood your requirement correctly, then you could use a macro to cycle through your data, and output the results you want:

Please Login or Register  to view this content.

**FlameRetired** · 11-02-2016, 02:17 PM

Hi Andrew and welcome to the forum.

I am not sure how "BHE" would factor in the rest of the criteria. Perhaps this will give you a good start with the rest.

Formula:

Please Login or Register  to view this content.

**A_W** · 11-03-2016, 03:57 AM

Thanks Olly - worked perfectly

**A_W** · 11-03-2016, 04:41 AM

Hi Olly,

I replied as solved but just realized that this gave incremental information, and I actually only need to add instances where the Acct-Status-Type is equal to Stop.
I also need to include the Acct-Output-Octets with a value above 4000 - this would be an 'or' statement of some sort I guess - so if either Acct-In 'OR' Acct-Out >4000 AND Acct-Status = Stop then record the entry - am I asking too much?

Thanks again for your help

**Olly** · 11-03-2016, 05:19 AM

No problem - try this:

Please Login or Register  to view this content.

**A_W** · 11-03-2016, 05:26 AM

You are a genius!! thanks again - does the trick...

**Olly** · 11-03-2016, 05:34 AM

Happy to help

Thanks for the feedback

Lookup in a range of cells and extracting cells based on values and criteria

LinkBack

Thread Tools

Rate This Thread

Display

Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Re: Lookup in a range of cells and extracting cells based on values and criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extracting data from cells based on criteria in other cells

Extracting data from a range that changes daily based on a cells criteria

Counting Number of Cells Based off Criteria of Other Cells in a Different Range

[SOLVED] lookup a range of cells and populate specific cells based on matching data

[SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells

define range of cells based on values that appear on other cells

Bookmarks

Bookmarks

Posting Permissions