Sorting, Counting a parts list

**AliGW** · 08-15-2023, 01:48 AM

I see you changed post #192 to this:

Not wishing to create conflicts.

Not half!!! I'm sick of the blame game. Look around at the average length of threads here: the length of yours is entirely down to you and your chaotic approach. It certainly is NOT of my doing.

I see you are now failing to read John's posts properly and act on them as requested. As you seem determined to continue in this haphazard fashion, I have withdrawn my assistance as stated in post #197 and I shan't be changing my mind this time.

As I mentioned before, you just aren't working with us. I've invested too much time in this already and being blamed for the length of time it's taking to resolve is no motivation to continue. You are flogging a dead horse. Good luck with the project.

**Pulsed Power** · 08-15-2023, 06:21 AM

macro results are coreect: YES

**JohnTopley** · 08-15-2023, 08:03 AM

Please Login or Register  to view this content.

I have retained "Dashboard" to collate the results which are posted to the Vendor PO sheet:

PLEASE note the PO sheets must reflect the Vendor name i.e "HIFI COLLECTIVE OP" not "HIFI OP"

**Pulsed Power** · 08-15-2023, 09:22 AM

Thank you
Received this error upon opening the file

**JohnTopley** · 08-15-2023, 09:31 AM

No idea as this (appears to b) a 365 error: click "Close" as it appears to have done the "repair". The only named ranges I used are VENDOR and VENDORS.

**Pulsed Power** · 08-15-2023, 09:35 AM

Why no info posted here

**JohnTopley** · 08-15-2023, 10:23 AM

See attached: make PO sheets identical size (rows and columns)

You will need add TAX etc calculation: SUBTOTAL is a SUM formula

**Pulsed Power** · 08-15-2023, 10:29 AM

Thank you
I am sure I will have more questions once I work with this

**Pulsed Power** · 08-15-2023, 01:44 PM

More than likely I will be beaten with a whip to ask this question:

Extraction of Parts Charts from a PDF File, instead of manual entry?

**JohnTopley** · 08-15-2023, 02:00 PM

See here:

https://www.klippa.com/en/blog/infor...?cn-reloaded=1

**Pulsed Power** · 08-21-2023, 02:15 PM

Having an opportunity to get back to this topic:

Why did the part# and value not carry over to the PO?

If you look at the MAIN Sheet these are listed, but not on any of the others?

The reason for asking is that one of my Vendors is not able to provide the parts, now I must change those parts to a different Vendor. The alternate vendor doesn't use the same part numbers, they use the values.

**JohnTopley** · 08-21-2023, 04:23 PM

I don't know what you are referring to as both PO sheets (in the test file provided) have the Vendor Part number and Cost.

**Pulsed Power** · 08-21-2023, 05:33 PM

These are an example of the items that must be shown in the PO

**Pulsed Power** · 08-21-2023, 05:37 PM

These part numbers & prices are specific to one vendor. They mean nothing to the alternate vendor.

**Pulsed Power** · 08-21-2023, 07:18 PM

I just realized that I had the scroll bar placed all the way to the right. Therefor it was not showing the data as the MAIN sheet was showing.

**Pulsed Power** · 08-25-2023, 01:28 PM

John

After a great deal of review I have reformatted the POWER SHEET and want to use this format for all SHEETS
Issue is hidden formulas and etc is playing havoc upon doing this. I can only hope you can see these issues, I can't begin to give you a written explanation. I think we need to remove all formulas and etc that have placed into spreadsheet and reapply. That would include Row 4

**JohnTopley** · 08-25-2023, 01:56 PM

Correct these errors in the file:

1. Extra row added into "POWER" so remove: row 3 HAS to be the headings
2, No header row in "Filter"

It will then work.

NO further work from me after being "shouted" at in your post.

**Pulsed Power** · 08-25-2023, 03:56 PM

Please when and where did you think I shouted at you? Was never my intention

**Marc L** · 08-25-2023, 04:00 PM

Obviously when the font you used was so big ‼

Before a moderator modified your post for 'legibility' …

**Pulsed Power** · 08-25-2023, 04:07 PM

1. Extra row added into "POWER" so remove: row 3 HAS to be the headings

Row 3 is my Headings

**Pulsed Power** · 08-25-2023, 04:09 PM

Obviously when the font you used was so big ‼ Before a moderator modified your post for 'legibility' …

That was a error that I created due to screen size. I didn't realize it was doing that until I hit the send

**Pulsed Power** · 08-25-2023, 04:24 PM

This recent work began due to missing OEM Part Numbers for unknown reasons.

When I went back to the individual sheets and attempted to input the missing parts the part magically appeared in the row. For instance Rows 64 & 65.

Why are the Row Numbers not in sequence, is this created by my sorting? Now I see it is simply jumping from Row 4 to Row 9, Row 20 to Row 27, Row 31 to Row 36 and so forth

**Pulsed Power** · 08-25-2023, 04:40 PM

I also notice another example on the Main Sheet:

Jumps from Row 24 to 26

Row 25 is not shown and that should be D603

**Pulsed Power** · 08-25-2023, 04:48 PM

Please see attached for D603:

**Pulsed Power** · 08-25-2023, 05:02 PM

My error once again: I stated D603 should have been C603

**Pulsed Power** · 08-25-2023, 05:43 PM

Parts disaster MAIN:

Right and Left Channel Boards should be identical. The data in the MAIN Sheet has been extremely distorted:

Yellow Capacitors are shown but no others

Green Resistors only four shown all others are missing

Transistor TR601 is missing

**Pulsed Power** · 08-25-2023, 06:20 PM

Tone Board
Drawing File and Excel File attached

**Pulsed Power** · 08-25-2023, 06:36 PM

FILTER BOARD
Attached Files
Drawing and Excel Sheet

**Pulsed Power** · 08-25-2023, 07:00 PM

MAIN BOARD
Attached Files
Drawing and Excel Sheet

**JohnTopley** · 08-26-2023, 03:07 AM

I have no idea why your are postingg all these circuit layouts and what you expect me to do. If you have been changing the data, then that is for you to resolve.

For example "POWER" line 3 has "OEM Part #"," Value"," ......" etc in the file you posted..

Right and Left Channel Boards should be identical. The data in the MAIN Sheet has been extremely distorted:

The code does not change the data in any worksheet so I do not know to what you are referring - other than the fact that you state that you sorted the data.

**Pulsed Power** · 08-26-2023, 04:03 AM

Missing Parts is the issue

**Pulsed Power** · 08-26-2023, 04:06 AM

I have no idea why your are postingg all these circuit layouts

Does it look to you that the Boards and associated EXCEL Sheet match? NO

**Pulsed Power** · 08-26-2023, 04:13 AM

This recent work began due to missing OEM Part Numbers for unknown reasons.

When I went back to the individual sheets and attempted to input the missing parts the part magically appeared in the row. For instance Rows 64 & 65.

Why are the Row Numbers not in sequence, Now I see it is simply jumping from Row 4 to Row 9, Row 20 to Row 27, Row 31 to Row 36 and so forth

These missing Rows are in every sheet

**JohnTopley** · 08-26-2023, 04:30 AM

Does it look to you that the Boards and associated EXCEL Sheet match? NO

These missing Rows are in every sheet

...... the fact that many of the sheets are FILTERED ? [so no data is missing, simply hidden]

**Pulsed Power** · 08-26-2023, 07:35 AM

If my parts are hidden, how do I know if the part is included?

Is this process difficult for you to understand:
1. Enter part information for each board into each sheet A,B,C & D manual entry
2. Search and enter replacement part information. E, F & G manual entry
3. Define a part number count. I, J, K, L, M & N Excel Sort and Count
4. Create a Purchase Order for parts. Purchase Order Sheet Excel internal transfer of data

Every Row must be verifiable throughout the complete process.

**Glenn Kennedy** · 08-26-2023, 07:43 AM

Originally Posted by Pulsed Power

Is this process difficult for you to understand:

Be careful with your language. One more like this and you'll be banned for a week, as a minimum.

**Pulsed Power** · 08-26-2023, 07:48 AM

In addition, Each Board needs it's own sheet and a template for rows 1, 2 & 3 created that is a constant from sheet to sheet.
When a new sheet is created the template loads to be consistent.

**Glenn Kennedy** · 08-26-2023, 07:52 AM

I've just seen your condescending comments at Post 232. It's time you took a break from the forum, while you consider the language you are using to people who FREELY give their time to help you out. You don't own them, or pay them. They do this for fun and a bit of a challenge. The last thing anyone needs is interacting with an angry head.

One week ban.

Final warning. One more and the ban will be permanent.

**AliGW** · 08-26-2023, 07:54 AM

There has been condescension throughout the thread towards everyone who has offered help. Thank you, Glenn - I was on the verge of doing something very similar.

**JohnTopley** · 08-26-2023, 09:08 AM

If my parts are hidden, how do I know if the part is included?

your code:

Please Login or Register  to view this content.

Remove ALL filtering and NO data will be hidden: to repeat, the macro does NOT filter/hide data..

**Marc L** · 08-26-2023, 09:23 AM

Originally Posted by Pulsed Power

If my parts are hidden, how do I know if the part is included?

As it's visual - so just opening eyes - if you can't obviously see the obvious
neither remember what you have done then stop to use Excel, do no waste anymore your time !
And by the way as Excel does not seem the appropriate tool according to your project …
Or maybe it's for a homework, can't be a pro stuff.

**FDibbins** · 08-26-2023, 11:40 PM

wow...just wow, I am speechless

**Pulsed Power** · 09-02-2023, 11:08 AM

Please accept my deep felt apology for the poor choice in wording. The frustration level did exceed all reasonable thinking and I will try very hard to be aware of this in the future.
I never intended to be rude to anyone in this process and did state on multiple occasions my gratitude.

If my parts are hidden, how do I know if the part is included?

Process to compile needed results:
1. Enter part information for each board into each sheet A,B,C & D manual entry
2. Search and enter replacement part information. E, F & G manual entry
3. Define a part number count. I, J, K, L, M & N Excel Sort and Count
4. Create a Purchase Order for parts. Purchase Order Sheet Excel internal transfer of data

Every Row must be verifiable throughout the complete process.

**Glenn Kennedy** · 09-02-2023, 11:19 AM

I have restored the two soft-deleted posts.

**Pulsed Power** · 09-02-2023, 11:31 AM

Is this a proper example of how I should respond to others?

As it's visual - so just opening eyes - if you can't obviously see the obvious
neither remember what you have done then stop to use Excel, do no waste anymore your time !
And by the way as Excel does not seem the appropriate tool according to your project …
Or maybe it's for a homework, can't be a pro stuff.

**Pulsed Power** · 09-02-2023, 12:05 PM

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

**Pulsed Power** · 09-03-2023, 08:46 PM

Maybe someone could provide an explanation of these steps:

Please Login or Register  to view this content.

**Pulsed Power** · 09-03-2023, 08:57 PM

Maybe some explanation of each step in this list

I

Please Login or Register  to view this content.

**Pulsed Power** · 09-03-2023, 10:30 PM

Originally Posted by Marc L

As it's visual - so just opening eyes - if you can't obviously see the obvious
neither remember what you have done then stop to use Excel, do no waste anymore your time !
And by the way as Excel does not seem the appropriate tool according to your project …
Or maybe it's for a homework, can't be a pro stuff.

BOARD NA-06331 RIGHT CHANNEL
PART # VALUE TYPE REPLACEMENT VENDOR VENDOR PART NUMBER COST EACH
TR602 2SA572W-45 BJT KSA992FTA MOUSER 512-KSA992FATA $0.39 Where is TR601?
TR603 2SA572W-45 BJT KSA992FTA MOUSER 512-KSA992FATA $0.39
TR604 2SC1124-2 BJT MJE15032G MOUSER 863-MJE15032G $1.35
TR605 2SC1124-2 BJT MJE15032G MOUSER 863-MJE15032G $1.35
TR606 2SC458C BJT KSC1815 MOUSER 512-KSC1815YTA $0.39
TR607 2SC734Y BJT KSC1845FTA MOUSER 512-KSC1845FTA $0.33
TR608 2SA561Y BJT KSA1013YTA MOUSER 512-KSA1013YTA $0.56
TR609 2SC680 B or C BJT MJE15033 MOUSER 863-MJE15033G $1.64
TR610 2SA566 B or C BJT MJE15032G MOUSER 863-MJE15032G $1.35
TR611 2SC1079Y 2SC1116 0:Y BJT MJ15003G MOUSER 863-MJ15003G $9.45
TR612 2SA679Y 2SA747 BJT MJ15004G MOUSER 863-MJ15004G $7.80
D601 1S1555 DIODE 1N4148 MOUSER 512-1N4148 $0.10
D602 1S1555 DIODE 1N4148 MOUSER 512-1N4148 $0.10
D603 1S1555 DIODE 1N4148 MOUSER 512-1N4148 $0.10
D604 1S1555 DIODE 1N4148 MOUSER 512-1N4148 $0.10
D605 1S1555 DIODE 1N4148 MOUSER 512-1N4148 $0.10
D606 1S1555 DIODE 1N4148 MOUSER 512-1N4148 $0.10
D607 10D-1 DIODE 1N5408 MOUSER 863-1N5408G $0.41
C602 100P CERAMIC MLCC MOUSER FA18C0G2A101JNU00 $0.35 Where is C601?
C604 0.1 CERAMIC MLCC MOUSER FA26C0G2A104JRU06 $1.06
C605 6P CERAMIC MLCC MOUSER FA18C0G2A6R8DNU00 $0.36
C606 6P CERAMIC MLCC MOUSER FA18C0G2A6R8DNU00 $0.36
C607 0.1 CERAMIC MLCC MOUSER FA26C0G2A104JRU06 $1.06
C608 6P CERAMIC MLCC MOUSER FA18C0G2A6R8DNU00 $0.36
C610 0.1 CERAMIC MLCC MOUSER FA26C0G2A104JRU06 $1.06
C611 0.0022 CERAMIC MLCC MOUSER FA18NP02A222JNU06 $0.47
C612 0.0022 CERAMIC MLCC MOUSER FA18NP02A222JNU06 $0.47
C613 0.22 MYLAR FILM MOUSER BFC241642204 $0.22
C614 0.22 MYLAR FILM MOUSER BFC241642204 $0.22
C615 0.22 MYLAR FILM MOUSER BFC241642204 $0.22
C617 0.1 CERAMIC MLCC MOUSER FA26C0G2A104JRU06 $1.06
C618 0.1 CERAMIC MLCC MOUSER FA26C0G2A104JRU06 $1.06
C619 1000P CERAMIC MLCC MOUSER FA18C0G2A102JNU00 $0.36
C620 1000P CERAMIC MLCC MOUSER FA18C0G2A102JNU00 $0.36
F601 5AMP GLASS https://www.mouser.com/datasheet/2/2...***-475466.pdf MOUSER 576-0311005.M $0.42
F602 5AMP GLASS https://www.mouser.com/datasheet/2/2...***-475466.pdf MOUSER 576-0311005.M $0.42
VR601 4.7K TRIMMER 3299P MOUSER 652-3296P-1-502LF $2.40
VR602 4.7K TRIMMER 3299P MOUSER 652-3296P-1-502LF $2.40
VR603 4.7K TRIMMER 3299P MOUSER 652-3296P-1-502LF $2.40
VR604 4.7K TRIMMER 3299P MOUSER 652-3296P-1-502LF $2.40
R605 5.6K 1P MOX MOX ROX MOUSER 279-ROX1SJ5K6 $0.46 Where is R601- R603. R604, R607 - R626, R630, 6333 - R634?
R606 5.6K 1P MOX MOX ROX MOUSER 279-ROX1SJ5K6 $0.46
R627 4.7 1P CEMENT CEMENT OHMITE MOUSER 588-WHB5R0FET $1.34
R628 4.7 1P CEMENT CEMENT OHMITE MOUSER 588-WHB5R0FET $1.34
R631 4.7K 1P MOX MOX MOS MOUSER 660-MOX1CT52R4R7J $0.46
R632 4.7K 1P MOX MOX MOS MOUSER 660-MOX1CT52R4R7J $0.46
R635 10 1P MOX MOX MOS MOUSER 588-41F10RE $1.73

**Pulsed Power** · 09-04-2023, 12:39 AM

Additional explanation is needed

1. Use code tags for VBA.

Please Login or Register  to view this content.

(or use the # button)

**AliGW** · 09-04-2023, 12:41 AM

Administrative Note:

You need to include code tags around your code.

I've added them for you this time. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags,

**JohnTopley** · 09-04-2023, 03:37 AM

... where they have always been: see "Main" in attached.

Look at Sheet "Rear": you will see the row numbers are BLUE which indicates the data has been FILTERED as do the "down arrows" at the top of each column.

The "down arrow" on "Vendor" has a dot which indicates this is the column being filtered. Click on this arrow and you will see which vendor has been filtered

Click on "Sort & Filter" then "Filter" and all will be revealed.

**Glenn Kennedy** · 09-04-2023, 03:46 AM

Originally Posted by Pulsed Power

Is this a proper example of how I should respond to others?

Actually, no. It isn't... as you guessed! The author of those words has had a couple of warnings about language choices.

**Pulsed Power** · 10-12-2023, 12:52 PM

AliGW you had offered at one time a method to count the part numbers for a total of each. John provided a Macro for this and that is just not working for me. Could you please provide your solution? I just want a count on each sheet and forget all that PO stuff.

**Pulsed Power** · 10-12-2023, 01:02 PM

For an example:

**AliGW** · 10-12-2023, 01:12 PM

Trying to help you in this thread was a complete nightmare, so I am afraid I shan’t be attempting to assist you any further. Hopefully someone else will feel willing to do so. I am sorry, but it’s a "no" from me.

**Pulsed Power** · 10-12-2023, 01:31 PM

I can very much understand your worries. I have spent a great deal of time since then to better understand what was provided.

**JohnTopley** · 10-12-2023, 01:39 PM

You should know that supplying images is useless so, if you want help, please supply a workbook showing expected results.

If the macro is now not working, what has changed?

**Pulsed Power** · 10-12-2023, 02:10 PM

Count how many times a part appears in the list and provide a total of each

Columns A:G are values
Columns I:N are extracted values

I manually extracted the information in I:N, my goal is to have a formula to extract the info A:G and place into I:N

**Pulsed Power** · 10-12-2023, 02:11 PM

Originally Posted by JohnTopley

You should know that supplying images is useless so, if you want help, please supply a workbook showing expected results.

If the macro is now not working, what has changed?

John Thank You for all the assistance but I tried to explain the issues before and just created more confusion.

**JohnTopley** · 10-12-2023, 03:51 PM

Why have you not posted a file: nothing can be done until we see the data.

**Pulsed Power** · 10-12-2023, 04:41 PM

New format

**Pulsed Power** · 10-12-2023, 05:09 PM

Once you open the file and look at it, I have several comments to make.

These changes have come from working with the previous sheets and understanding that what I asked for needed additional thoughts.

**Pulsed Power** · 10-12-2023, 10:07 PM

https://1drv.ms/x/s!Ahn4hs1BmKfvhJI5...yLfxg?e=4mVd0O

Columns A:E is manually entered data gathered from hardcopy OEM Electronic Schematics

Columns G:NA is data extracted from A:E. Needs to be shown as sorted and counted

I have randomly colored the rows, if there is a systematic method for row colors that would be nice. I find the colors help to visually track from row to row and column to column.

i have not inserted any formals or anything outside of numbers and letters for each cell. If you find something hidden please remove.

Why do some cells have a black triangle in the top left corner?

FYI: Resistor values are shown with a K which represents thousands and M which represents Millions

**AliGW** · 10-13-2023, 01:13 AM

If you are using this in the browser version of Excel, then you are not going to be able to use VBA for it - is that whey John's code has 'never worked'???

Instead of a link to your OneDrive, provide an attachment as you alwasy have done before, please. Thanks.

**Pulsed Power** · 10-13-2023, 02:12 AM

Please see file attached as requested

**JohnTopley** · 10-13-2023, 02:51 AM

The posted file bears no resemblence whatsoever with the file on which the VBA was based - providing the data for a Vendor PO - so I am not surprised it does not work.

You are back to square one as I (and I suspect any other respondent) have no idea what it is now required.

**Pulsed Power** · 10-13-2023, 10:13 AM

Originally Posted by JohnTopley

The posted file bears no resemblence whatsoever with the file on which the VBA was based - providing the data for a Vendor PO - so I am not surprised it does not work.

You are back to square one as I (and I suspect any other respondent) have no idea what it is now required.

Columns A:E is manually entered data gathered from hardcopy OEM Electronic Schematics

Columns G:NA is data extracted from A:E. Needs to be shown as sorted and counted

I have randomly colored the rows, if there is a systematic method for row colors that would be nice. I find the colors help to visually track from row to row and column to column.

i have not inserted any formals or anything outside of numbers and letters for each cell. If you find something hidden please remove.

Why do some cells have a black triangle in the top left corner?

FYI: Resistor values are shown with a K which represents thousands and M which represents Millions

**JohnTopley** · 10-13-2023, 10:35 AM

The data you supplied is (IMHO) completely out of sync:

In "TONE"/"MAIN AMPS" Column C "Volts/watts" is not numeric but TEXT which I think is actually TYPE.

Equally TYPE in column I ("Resistors") is frequently "CF" but does not appear in "erroneous" column C (see sheet "TONE").

If Data is OK, then COUNTIFS function should suffice.

e.g. in J5 of "Power Supply"

Formula:

Please Login or Register  to view this content.

copy down to J12

**Pulsed Power** · 10-13-2023, 12:15 PM

So I cleaned up the data on the Tone Sheet, the black triangles in the upper left hand corners are still there, what have I done incorrectly?

**JohnTopley** · 10-13-2023, 12:32 PM

No black triangles for me!!

**Pulsed Power** · 10-13-2023, 12:46 PM

Please see attached

**Pulsed Power** · 10-13-2023, 12:57 PM

Originally Posted by JohnTopley

The data you supplied is (IMHO) completely out of sync:

In "TONE"/"MAIN AMPS" Column C "Volts/watts" is not numeric but TEXT which I think is actually TYPE.

Equally TYPE in column I ("Resistors") is frequently "CF" but does not appear in "erroneous" column C (see sheet "TONE").

If Data is OK, then COUNTIFS function should suffice.

e.g. in J5 of "Power Supply"

Formula:

Please Login or Register  to view this content.

copy down to J12

I should insert this formula at each count location? Maybe you could break the Formula down as too the purpose of each item in the Formula?

**AliGW** · 10-13-2023, 01:04 PM

The GREEN triangles indicate that Excel has detected text that looks like a number and is offering to convert it for you.

**Pulsed Power** · 10-13-2023, 01:25 PM

Originally Posted by AliGW

The GREEN triangles indicate that Excel has detected text that looks like a number and is offering to convert it for you.

Do I need to click on each individual cell to convert or is there a way to change all at once?

**JohnTopley** · 10-13-2023, 02:15 PM

Re the formula: why don't YOU make the effort to understand COUNTIFS: there are numerous explanations and examples on the internet.

and sheet "MAIN AMPS" needs amending.

**Pulsed Power** · 10-13-2023, 06:47 PM

Thank you for the additional information

**Pulsed Power** · 10-13-2023, 06:48 PM

As you requested

**Pulsed Power** · 10-13-2023, 07:08 PM

Count inserted into J5:J12, I don't see any result

**jeffreybrown** · 10-13-2023, 07:11 PM

I'm pretty sure if you want a count to populate, try starting the formula off with "="

**Pulsed Power** · 10-13-2023, 07:31 PM

Originally Posted by jeffreybrown

I'm pretty sure if you want a count to populate, try starting the formula off with "="

That works! Thank you!

**jeffreybrown** · 10-13-2023, 07:39 PM

You are very welcome. Happy to help!

**Pulsed Power** · 10-13-2023, 07:39 PM

Only in that column. Something must change to use in:
P5
U5
Z5
AE5
AK5

**jeffreybrown** · 10-13-2023, 08:05 PM

Yes, the references need to change. Example, in P5, you only have two lookup references versus the three you used in J5. Copy the formula from J5 to P5 and then place your cursor in the formula bar. All of the references will highlight by color.

Follow those colors and adjust the references to fit.

**Pulsed Power** · 10-13-2023, 10:24 PM

How I interpret the formula, but 99% sure my thoughts are incorrect

COUNTIFS
($A:$A,"R*", Look at column A and find all R's
$B:$B,$G5, Look at column B place value in G5
$C:$C,$H5, Look at column C place data in H5
$D:$D,$I5) Look at column D place data in J5

**AliGW** · 10-13-2023, 11:05 PM

Here's the definition of the function:

https://support.microsoft.com/en-gb/...c-aa8c2a866842

Excel will count:

1. Cells in A that start with R.
2. Cells in B that match G5.
3. Cells in C that match H5.
4. Cells in D that match I5.

It will count only rows in A:D where ALL FOUR criteria are met.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

**Berniep** · 10-13-2023, 11:08 PM

Yes, I agree with Marc L - use the Filter function. I suggest you turn the data into an Excel table (Insert table) and then filter the necessary columns until you get exactly what you need. You can then save these filters by making a coy of the tab and changing the name so you have a record of each filter.

**Pulsed Power** · 10-13-2023, 11:22 PM

Originally Posted by Berniep

Yes, I agree with Marc L - use the Filter function. I suggest you turn the data into an Excel table (Insert table) and then filter the necessary columns until you get exactly what you need. You can then save these filters by making a coy of the tab and changing the name so you have a record of each filter.

Marc L, I don't find any input from Marc L?

**Pulsed Power** · 10-13-2023, 11:28 PM

@AliGW

Thank you very much for breaking this down where it becomes easy to understand:

**AliGW** · 10-13-2023, 11:41 PM

Please mark as solved etc. as described in post #286.

**Marc L** · 10-14-2023, 04:13 AM

Originally Posted by Pulsed Power

Marc L, I don't find any input from Marc L?

If only you had well followed your thread ‼

Restart from the beginning …

**FDibbins** · 10-15-2023, 12:14 AM

Pulsed Power of 289 posts, 158 (more than 54%) were yours, with frequent multiple posts from you.

Please restrain yourself from posting such multiple posts, give more thought to what you want to say, and post that all in 1 CONCISE post please

Also, please try and remember that while those circuit may mean something to you, to most of us here, they are just pretty, meaningless pictures - and we cant work with pictures

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list

Re: Sorting, Counting a parts list