[구글스프레드시트] 한 열에 문자와 숫자가 섞여 있을 때 Query함수를 이용한 Filtering 방법
Synopsis
Query #문자와_숫자가_섞여있을때_필터링 -------------------------------------------------------------------------------- 좋아요/구독 눌러주세요.
![[구글스프레드시트] Query함수_한 열에 숫자와 문자가 섞여 있을 때_Query함수는 자동으로 열의 데이타 유형을 결정한다.](https://i.ytimg.com/vi/B2kpVS6ON7w/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_AmAAtAFigIMCAAQARhlIGUoZTAP&rs=AOn4CLDAY6u4NdV2dcEIeYIKw-2QatxKVg)
![[구글스프레드시트] Query함수에서 숫자를 날짜로 인식하지 못할 때!](https://i.ytimg.com/vi/b-Yc5wPJdKU/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDXLEU5tZm4tKzWM3V0qox6z2FgRg)
![[구글스프레드시트] Flatten + Query 함수를 이용한 고유값 및 개수 구하기](https://i.ytimg.com/vi/o_J4NlnW5Nk/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_AmAAtAFigIMCAAQARhKIGUoVTAP&rs=AOn4CLABXADa5V5h7wGntkdehtZ5K3qXkw)
![조건에 맞는 데이터만 불러오기(구글시트 FILTER함수)[함수사용법]](https://i.ytimg.com/vi/BLsjzNqqoyY/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLCLWi72zPUJXDbFC52oRqc9If2o1A)
![[구글 스프레드시트] (Query, Filter)해당 행에 "가"와 "나"를 동시에 가지고 있는 모든 행 추출하는 2가지 방법](https://i.ytimg.com/vi/5g7iBpPDvi0/hqdefault.jpg?sqp=-oaymwEcCOADEI4CSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBh0PS9jMIA0mlYXOKYskusKf0UWQ)
![[구글스프레드시트] Query 함수를 이용한 판매액 평균 이상/이하 데이타 가져오기](https://i.ytimg.com/vi/lxcQAfV0BFg/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB0gaAAuADigIMCAAQARhlIGUoZTAP&rs=AOn4CLBNQdnSDAv0dLZ72fjXJ_fg5fI_Qg)
![원하는 문자,숫자를 쉽게 추출하기(구글시트 REGEXEXTRACT함수)[함수소개-기초]](https://i.ytimg.com/vi/RliUQ-7WrjA/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLA1xW8LUdYZgpvC9KV1QnKLPHUxjA)
![[구글스프레드시트] Unpivot + Query + label를 이용한 제목행 없애기](https://i.ytimg.com/vi/cwf7dA7tc9o/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBxEGrmMNR9MufOFsV4hI-alK2Edw)
![[구글스프레드시트] Query_행축,열축에서 날짜가 숫자로 표시되는 경우 처리 방법](https://i.ytimg.com/vi/kwL5oFWQZz4/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB_gmAAtAFigIMCAAQARhlIGUoZTAP&rs=AOn4CLCjqrZQ-216U7VMyHFt2gBwngdzgg)
![[구글스프레드시트] Query+textjoin+sequence 함수를 이용한 범위에서 알파벳 개수 구하기](https://i.ytimg.com/vi/OJAq_Cdd88U/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB0gqAAoAGigIMCAAQARhlIGUoZTAP&rs=AOn4CLBWEaCUHtxi1Qp_e50W9MuwGfRyag)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.