You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Nef
@Chalfie
The data entry will be the longest thing. If you were to take the table I linked to then I would do this
Column A = Type = fuse or circuit breaker
Column B = standard
Column C = rating
Column D = resistance
You could use maxifs or you could use filter (https://support.microsoft.com/en-gb/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759) which would let you say
"for type and standard at this rating what is the resistance?"
or if you wanted a flashy dashboard you could use a couple of slicers (https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d#:~:text=Click%20anywhere%20in%20the%20table%20or%20PivotTable%20for%20which%20you,every%20field%20that%20you%20selected.)