Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
2.4k views
in Technique[技术] by (71.8m points)

excel - Google Sheet Function to pull data from 6 different sheets

I have 6 different google forms tied to 6 tabs in my workbook. I would like to pull all the responses from these 6 sheets to a central sheet.

The items provided in the survey that I would like to include are:

  • Signup Date
  • First Name
  • Last Name
  • Phone
  • Email
  • Raw State
  • Cities
  • Min Year Built
  • Min List Price
  • Max List Price
  • Min Sqft
  • Max Sqft
  • Min Bedroom
  • Foreclosure

I have used the Query function to successfully pull the following items:

  • Signup Date
  • First Name
  • Last Name
  • Phone
  • Email
  • Raw State

But am unable to pull the following:

  • Cities
  • Min Year Built
  • Min List Price
  • Max List Price
  • Min Sqft
  • Max Sqft
  • Min Bedroom
  • Foreclosure

I have attempted to pull this data with a new query function but it pulls the data incorrectly. I have also tried an Index(Match function but unable to pull from multiple sheets.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...