Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 ngrunoz
		
			ngrunoz
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Guys.
I have attached a document with Sample data and another tab with desired results.
I want to create a table with Data from column A to H and Aggr count distinct Miner name that I get the total number of miners irrespectively of the section they were involved in at that pint in time.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Don't see anything attached
 
					
				
		
 ngrunoz
		
			ngrunoz
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Apologies.
Attached herewith.
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		May be this
=Count(TOTAL DISTINCT [Miner name])
 
					
				
		
 ngrunoz
		
			ngrunoz
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you so much.
