Can someone tell me why the first column is not displaying all info?

E

eqeafarms

New Member
Joined
Feb 2, 2024
Messages
9
Office Version
  1. 365
Platform
  1. Windows
emp_exception_log_v2.2.xlsm
AB
1Investigation IDSample Location:
2bharvest ss infeed side guard-001bharvest ss infeed side guard
3bharvest blade-002bharvest blade
4bharvest outfeed belt-003bharvest outfeed belt
5bharvest ss outfeed guard-004bharvest ss outfeed guard
6bpack mini scale belt-005bpack mini scale belt
7bpack ss table top-006bpack ss table top
8p2harvest interior WIP tote-007p2harvest interior WIP tote
9lpack ss incline guard-008lpack ss incline guard
10lpack line 1 proseal film bar-009lpack line 1 proseal film bar
11lpack line 1 proseal film bar-009lpack line 1 proseal film bar
12lpack line 1 proseal film bar-009lpack line 1 proseal film bar
13lpack line 2 proseal film bar-010lpack line 2 proseal film bar
14lpack line 2 proseal film bar-012lpack line 2 proseal film bar
15lpack line 2 proseal film bar-012lpack line 2 proseal film bar
16lpack belt #6 ss guard-011lpack belt #6 ss guard
17lpack incline #1-012lpack incline #1
18lpack incline #4-013lpack incline #4
19lpack incline #2-014lpack incline #2
20lpack incline #2 side flap-015lpack incline #2 side flap
21lpack incline #1 ss guard-016lpack incline #1 ss guard
22lpack incline #2 ss guard-017lpack incline #2 ss guard
23lpack upper shaker forks-018lpack upper shaker forks
24lpack hopper #1-019lpack hopper #1
25#N/Alpack incline #2 ss guard
26lpack outfeed shaker #2-020lpack outfeed shaker #2
27#N/Alpack outfeed shaker #2
28#N/Alpack outfeed shaker #2
29lpack outfeed shaker #3-021lpack outfeed shaker #3
30#N/Alpack outfeed shaker #3
31#N/Alpack outfeed shaker #3
32lpack outfeed shaker #4-022lpack outfeed shaker #4
33#N/Alpack outfeed shaker #4
34#N/Alpack outfeed shaker #4
35lpack outfeed shaker #5-023lpack outfeed shaker #5
36lpack lower belt ss guard-024lpack lower belt ss guard
37bharvest exterior WIP tote-025bharvest exterior WIP tote
38lpack infeed/dump belt-026lpack infeed/dump belt
39#N/Alpack infeed/dump belt
40#N/Alpack infeed/dump belt
41lpack middle belt side flap-027lpack middle belt side flap
42lpack outfeed belt -028lpack outfeed belt
43lpack outfeed belt side flap-029lpack outfeed belt side flap
44#N/Alpack outfeed belt side flap
45#N/Alpack outfeed belt side flap
46lpack ss infeed guard-030lpack ss infeed guard
47lpack ss lower shaker-031lpack ss lower shaker
48lpack middle belt ss guard-032lpack middle belt ss guard
49lpack incline #2 ss railing-033lpack incline #2 ss railing
50#N/Alpack incline #2 ss railing
51#N/Alpack incline #2 ss railing
52#N/Alpack incline #2 ss railing
53lpack incline #2 platform underside-034lpack incline #2 platform underside
54lpack incline #3 ss railing-035lpack incline #3 ss railing
55lpack incline #4 platform underside-036lpack incline #4 platform underside
56lpack belt #3 ss side guard-037lpack belt #3 ss side guard
57lpack belt #5 ss side guard-038lpack belt #5 ss side guard
58lpack belt #7 ss side guard-039lpack belt #7 ss side guard
59lpack ss tote stand-040lpack ss tote stand
60#N/Alpack ss tote stand
61lpack incline #4 ss railing-041lpack incline #4 ss railing
62#N/Alpack incline #4 ss railing
63p2harvest ss WIP scale-042p2harvest ss WIP scale
64#N/Ap2harvest ss WIP scale
65mgharvest ss tote platform-043mgharvest ss tote platform
66lpack underside of platform over belts 3-4-044lpack underside of platform over belts 3-4
67lpack outfeed shaker #1-045lpack outfeed shaker #1
68mgharvest incline belt-046mgharvest incline belt
69bpack bottom packout belt-047bpack bottom packout belt
70lpack belt #8 ss side guard-048lpack belt #8 ss side guard
71lpack ss outfeed shaker-049lpack ss outfeed shaker
72lpack incline #1 ss underside-050lpack incline #1 ss underside
73p2harvest exterior WIP tote-051p2harvest exterior WIP tote
74p2harvest blue incline side panel-052p2harvest blue incline side panel
75p2harvest outfeed belt-053p2harvest outfeed belt
76lpack incline belt #2-054lpack incline belt #2
77mgharvest blade-055mgharvest blade
78#N/Amgharvest blade
79#N/Alpack ss infeed guard
80#N/Alpack ss infeed guard
81lpack ss middle shaker-056lpack ss middle shaker
82#N/Alpack ss middle shaker
83mgharvest incline roller guard(under incline belt)-057mgharvest incline roller guard(under incline belt)
84lpack belt #4-058lpack belt #4
85lpack incline belt-059lpack incline belt
86#N/Alpack incline belt
87lpack white belt side flap-060lpack white belt side flap
88lpack white belt ss side guard-061lpack white belt ss side guard
89lpack belt #1 ss side guard-062lpack belt #1 ss side guard
90lpack pack station-063lpack pack station
91bpack proseal film bar-064bpack proseal film bar
92mgharvest ss incline guard-065mgharvest ss incline guard
93lpack mix-to-jasa long conveyor(after post-mix incline #2)-066lpack mix-to-jasa long conveyor(after post-mix incline #2)
94bharvest interior WIP tote-067bharvest interior WIP tote
95lpack incline #4 ss underside-068lpack incline #4 ss underside
96lpack incline #1 ss handrail-069lpack incline #1 ss handrail
97lpack incline belt #3-070lpack incline belt #3
98lpack upper chute-071lpack upper chute
99lpack post-mix upper ss shaker-072lpack post-mix upper ss shaker
100p2harvest interior WIP tote-007p2harvest interior WIP tote
101lpack incline belt #1-073lpack incline belt #1
Sheet2
Cell Formulas
RangeFormula
A2:A101A2=B2&TEXT(IF(COUNTIF(B$2:B2,B2)>1,MATCH(B2,$B$2:$B$13,0),COUNTA(UNIQUE(B$2:B2))),"-000")
B2:B101B2=CONCAT('zone1 oos log'!E6," ",'zone1 oos log'!G6)
 
Last edited:

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Your match range is set to end at row 13.

I don't really understand how adding a number benefits you when the codes are unique anyway.
 
Upvote 1
RoryA said:
Your match range is set to end at row 13.

I don't really understand how adding a number benefits you when the codes are unique anyway.
Click to expand...
Thank you I copied and pasted this from the internet bc I'm seriously ignorant. The codes are unique but it depends on if the investigation has been closed and then the site fails environmental sampling further down the line, so it'd be the same location but would be a new case as I plan to name them so they don't all lump together in those cases. Sorry for confusion, thank you for helping me despite how stupid my questions are.
 
Upvote 0
I still don't see how the numbers really help, but you'd want something like:

Excel Formula: 
=B2&TEXT(IF(COUNTIF(B$2:B2,B2)>1,MATCH(B2,$B$2:$B2,0),COUNTA(UNIQUE(B$2:B2))),"-000")
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

E
  • Question Question
Hello! Please help me make my workbook better
Replies
3
Views
230
Micron
M
D
  • Question Question
Transfering data over multiple Workbooks; Excel 2010
Replies
0
Views
953
Da3d4lu5
D
A
  • Question Question
Userform - Second Combobox Based on First Combobox
Replies
6
Views
3K
aznpanther
A

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

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