ever tried v-lookup?
nah index(,match is the way to go
It split column a,b,c rows 1-600 into column a 1-601 b 601-1200 c1201-1800. I put them side by side but they are not all exactly the same. I want to match them up by the id number at the beginning of each row.
Hi,I ran a report at work and it divided the rows up into 3 sets of 600 rows instead of 1 wide row of 600. Is there any way to put them side by side matching the user Id of each row.Please let me know if I can be any clearer. Tia
how do i trun off scientific notation?
yes all data i enter should be as is