Forum Discussion
Extracting table values if values in two columns have identical values in other rows
Hi guys, Can someone please help me with a formula for the following task? I have over 40,000 rows of data in 'Table 1', I've extracted a sample. I need to analyse only cells which con...
sql:
select b.* from (select f02,f03 from Sheet2 group by f02,f03 having(count(1))>1) as a join Sheet2 as b on a.f02=b.f02 and a.f03=b.f03 ;