• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

EXCEL Question for Work (Low Tech)

S

sub-80

Senior member
Hey;

I am using excel as Office is the only identical software in all the PCs in my workplace. What I want to do for example: I have a sheet with equipment for each location in columns and another sheet with database of equipment name and condition (run, breakdown, maintenance,etc.) So what I want is to have a 3rd sheet with all the locations and number of breakdowns per locations.

It would be similar to Countifs but instead of the criteria being a cell it would be an array of cells


Any help?


Thanks.
 
Typically, generating fully dynamic content in Excel would require a macro. There are some crazy things that you could do with array formulas, but I don't know if I'd recommend it. I've worked with them in the past, and they're kind of slow and generally a pain to work with.

Now, if you have some static values and you just want to fill out some attributes, you can just perform a vlookup to grab the data from one of the other two sheets. For example, it sounds like your first sheet could just have a column inserted beside the equipment name, and a vlookup uses that name to retrieve the status from the second sheet. Keep in mind that if you do use vlookup, it requires the lookup value to be in the first column of the source table.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top