[Free] Advance Google Sheet Extension with Filter and Query

Extensions
#21

User col index ? Which mean, for every user you are using col.?? We and all use only row

To make us clear show your gsheet screenshot

#22

Screenshot 2022-06-05 195512
Screenshot 2022-06-05 1955121920×356 84.3 KB

i want to het user index by using column c

#23

Create a new col A with autofill numbers and use select A where C =

#24

how i dont understand

#25

No man, in col A right click , create a new col left side… so existing data will be moved one col to right side

#26

ok i understood

#27

Great extension
@Kuldeep_Pilaniya1
Can you add some more blocks for delete row
if possible
Like In Coloum A there are 5 Xyz and some others
I want to delete all 5 xyz at same time

#28

Upcoming Blocks in next month we are working on these blocks
update row
update cell
update column
update range
create row
create column
Apply Formula
Apply Filter
SQL Query
Delete Row
Delete Column

3 Likes
#29

can i use this type query?
like

SELECT 
id, 
(
   3959 *
   acos(cos(radians(37)) * 
   cos(radians(lat)) * 
   cos(radians(lng) - 
   radians(-122)) + 
   sin(radians(37)) * 
   sin(radians(lat )))
) AS distance 
FROM markers 
HAVING distance < 28 
ORDER BY distance LIMIT 0, 20;