Forum Discussion

Copper Contributor

Jul 20, 2023

Solved

Data gathering

I am trying to create a separate sheet attached to this one that will automatically update collectively as I input data (sold for, who sold to, bid number, item name (have received column), i...

Formulas and Functions

PeterBartholomew1
Jul 24, 2023
AdultCareCenterNSV
This is your file with my formula copied to the summary sheet. The names had to be adjusted to the new situation but, other than that things went reasonably well. My intention is to show how an array of bidder reports can be generated by a single formula using a spilt range.

Items List for excel help.xlsx35 KB

mathetes

Silver Contributor

Jul 20, 2023

AdultCareCenterNSV

Definitely possible. If you care to post a copy of that workbook (putting it on OneDrive or GoogleDrive with a link here that grants access) I or somebody else could directly show you how.

But if you are comfortable adding the functionality yourself, it should be a straightforward application of the FILTER function, and that is introduced very well in this YouTube video.

AdultCareCenterNSV

Copper Contributor

Jul 21, 2023

mathetes I'd be happy to. Thanks for the help!

https://docs.google.com/spreadsheets/d/1dktXg96tAi0I6PllRh0MnJlW1abxE3s0/edit?usp=drive_link&ouid=101681890012899406119&rtpof=true&sd=true

peiyezhu
Bronze Contributor
Jul 22, 2023
Open full text.editor of this forum，you can upload and share your file here directly.
mathetes
Silver Contributor
Jul 22, 2023
Sorry --this link doesn't grant access. Unless you intend that I alone have access you should do it again but select the option that gives the user access to the file.