sum text if ?

K

KCLA1785

New Member
Joined
Nov 13, 2014
Messages
19
Hi There,
I have a query that updates! its a stock available query column A is the "code" column B is the "stockCode" that goes into "Code" Column I tells me if the stock is "Available" or "Insufficient Stk" for each item, now this query moves as information is updated so numbers in cells are subject to change ?
So i want column J to tell me if all cells in column A are the same number then look at column I and if all corresponding cells in I return "Available" then result = "1"
I hope this makes sense
Thank You for your time :)
A B C D E F G H I J
[TABLE="width: 925"]
<tbody>[TR]
[TD]Code[/TD]
[TD]StockCode[/TD]
[TD]Required[/TD]
[TD]StoreQty[/TD]
[TD]OnOrder[/TD]
[TD]Committed[/TD]
[TD]Location[/TD]
[TD]Availability[/TD]
[TD]Availabilty 2[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]0114-092-0006[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]0113-012-0002[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]0114-194-0002[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]0114-144-5200[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]50BRSGY-50L[/TD]
[TD]3[/TD]
[TD]39[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]50BRSGY-20L[/TD]
[TD]8[/TD]
[TD]31[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]09A027[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]51A016090109HEXSTDM[/TD]
[TD]24[/TD]
[TD]166[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]51CZ1008FZ[/TD]
[TD]24[/TD]
[TD]544[/TD]
[TD]0[/TD]
[TD="align: right"]164[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0001[/TD]
[TD]50BZRH067[/TD]
[TD]7[/TD]
[TD]15.7[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]0114-092-0003[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]0113-012-0001[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]0114-194-0001[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]0114-144-5200[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient Stk[/TD]
[TD]Insufficient Stk[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]50BRSGY-50L[/TD]
[TD]4[/TD]
[TD]39[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]50BRSGY-20L[/TD]
[TD]6[/TD]
[TD]31[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]09A027[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]51A016075109HEXSTDM[/TD]
[TD]2[/TD]
[TD]66[/TD]
[TD]0[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]51A016090109HEXSTDM[/TD]
[TD]22[/TD]
[TD]166[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]51CZ1008FZ[/TD]
[TD]24[/TD]
[TD]544[/TD]
[TD]0[/TD]
[TD="align: right"]164[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
[TR]
[TD]0113-011-0002[/TD]
[TD]50BZRH067[/TD]
[TD]3[/TD]
[TD]15.7[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
you could count the cells that are non-blank using counta(A:A) then -1 to ignore the title
then count the cells with column A compared to A1 countif(A:A,A2)

counta(A:A)-1=countif(A:A,A2) if true then you know ALL the cells in column A are the same code
then see if a count of Available is the same countif(I:I,"available")

so putting all together
=AND(COUNTA(A:A)-1=COUNTIF(A:A,A2),COUNTIF(A:A,A2)=COUNTIF(I:I,"available"))
if true then you want a 1

=IF(AND(COUNTA(A:A)-1=COUNTIF(A:A,A2),COUNTIF(A:A,A2)=COUNTIF(I:I,"available")) , 1 , "" )
 
Upvote 0
Hi Wayne,Thank you for the reply :) oh im working with micro office 2007,
however i have led you a little astray as the table pasted incorrect? there are no spaces between each row and the table is actually some 75,000 rows deep with roughly 36,500 different part numbers ? so any of the formula's you sent didint work and took between 5 -10 minutes to calculate ?
Do You Have any other suggestions ? here is a better idea of table im dealing with
Code StockCode Required StoreQty OnOrder Committed Availabilty Availabilty2 Availability3
[TABLE="width: 1015"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]0114-010200-112705[/TD]
[TD]0114-061-0001[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-010200-112705[/TD]
[TD]0114-141-5101[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-010200-112705[/TD]
[TD]0114-011-0002[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-010200-112705[/TD]
[TD]0114-541-0207[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-010200-112705[/TD]
[TD]Z0114-991-5005[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]0114-092-0002[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]0114-012-0001[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]0114-194-0001[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]0114-144-5200[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]09A027[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]51A016090109HEXSTDM[/TD]
[TD]23[/TD]
[TD]136[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]51A016110129SCHSTDM[/TD]
[TD]1[/TD]
[TD]64[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]51CZ1008FZ[/TD]
[TD]23[/TD]
[TD]256[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]50BRSGY-20L[/TD]
[TD]10[/TD]
[TD]31[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]50BRSGY-50L[/TD]
[TD]4[/TD]
[TD]39[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0002[/TD]
[TD]58AAWS46020LTR[/TD]
[TD]20[/TD]
[TD]-180[/TD]
[TD]0[/TD]
[TD="align: right"]603[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]0114-092-0004[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]0114-012-0002[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]0114-194-0002[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]0117-194-1004[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]0114-144-5200[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]09A027[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]51A016090109HEXSTDM[/TD]
[TD]23[/TD]
[TD]136[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]51A016110129SCHSTDM[/TD]
[TD]1[/TD]
[TD]64[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]51CZ1008FZ[/TD]
[TD]23[/TD]
[TD]256[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]50BZRH067[/TD]
[TD]3[/TD]
[TD]15.7[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]50BRSGY-20L[/TD]
[TD]4[/TD]
[TD]31[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]50BRSGY-50L[/TD]
[TD]4[/TD]
[TD]39[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0004[/TD]
[TD]58AAWS46205LTR[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]0114-092-0010[/TD]
[TD]1[/TD]
[TD]-2[/TD]
[TD]2[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]0114-012-0003[/TD]
[TD]1[/TD]
[TD]-2[/TD]
[TD]2[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]0114-194-0004[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]09A027[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]50BRSGY-20L[/TD]
[TD]20[/TD]
[TD]31[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]51A016090109HEXSTDM[/TD]
[TD]23[/TD]
[TD]136[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]51A016100129SCHSTDM[/TD]
[TD]1[/TD]
[TD]37[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]51CZ1008FZ[/TD]
[TD]23[/TD]
[TD]256[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]Available[/TD]
[TD]Available[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0114-011-0006[/TD]
[TD]58AAWS46020LTR[/TD]
[TD]20[/TD]
[TD]-180[/TD]
[TD]0[/TD]
[TD="align: right"]603[/TD]
[TD][/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0114-012-0402[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0114-012-0201[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0114-012-0202[/TD]
[TD]1[/TD]
[TD]-2[/TD]
[TD]2[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0117-012-0101[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0117-012-0701[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0114-504-0104[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0114-504-0103[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0117-504-0104[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0117-504-0103[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]0114-012-0001[/TD]
[TD]0114-804-0101[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[TD]N/A[/TD]
[TD]Insufficient [/TD]
[TD]Insufficient [/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
you may be able to use a pivot table
perhaps a sample sheet and the results expected shown or on another sheet
you can add to a share like onedrive , dropbox or icloud - those are the only ones i will use
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Solved
Export some data if a condition is met.
Replies
2
Views
100
harzer
H
A
  • Solved
Lookup PAAF ID based on Worker ID and date range
Replies
3
Views
145
Fluff
Fluff
H
  • Solved
Copy rows if cells in column "K" end with either "X" or "x".
Replies
3
Views
250
rollis13
rollis13
H
  • Solved
Creation of arrows for 2 family trees.
Replies
8
Views
414
harzer
H
E
  • Solved
Returning specific texts within a wide range of data coming from the Web
Replies
8
Views
344
Peter_SSs
Peter_SSs

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top