Comments
-
@Andrée Starå THANK YOU! I used an Index/Match formula WORKED PERFECTLY!!! LOVE this community.
-
@Darren Mullen The 3 'GC Bid sheets' look exactly the same only with 1 column for their individual bid. @Andrée Starå This solution would be used over and over again by our team. I thought I could use DataMesh, however, DataMesh goes across the sheet (left to right) whereas I need data from one entire column ('GC #1 Bid)…
-
@Danielle Arteaga WELL that was an out of the box solution that actually works!!! Simple, easy, unconventional, but works. Thanks!!!
-
@Andrée Starå Three leading zeros is the max
-
@Andrée Starå This works beautifully until text in the cell is '0010' or '0100'. In these instances I need to return '10' and '100'.
-
AGREED - A MUST !!!!!!
-
@Jake Gustafson @Frank s THANK you for the question @Jake Gustafson and THANK YOU for the answer @Frank S. I have a situation where 83 worksheets are shared to the same individuals (external partner). We have had a request twice now to add 'so and so' to the access of these same 83 worksheets. If we had employed sharing…
-
@Genevieve P. I am using Data Mesh, not Data Shuttle. I don't see the option to clarify the 'column type' in Data Mesh??
-
@Genevieve P.
