building

I am building a fantasy football board. The board is finished and working, but the next step into it would be having the players fall off the list on the individual positions sheets once selected. i am having trouble with it and any help would be appreciated.

Can anyone point me to a good resource for learning how to do some basic analytics in Excel? What I'm trying to learn how to do is look at all the operating and maintenance costs of hundreds of facilities and determine which ones cost the least/most overall. Also to look for cases where a...

Good evening friends, I am looking to build a digital version of the ancient manual logbooks currently used to track personnel entering/exiting our facility. I currently have badges with barcodes and scanners that capture personal information (Name, employee ID number, department), and use a...

HELP :D I'm building a formula that would find between two dates and SUM which if found this on your site very useful formula =COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64) The formula helps me find all the dates I needed to count within certain worksheets. for example I have this...

My goal is to calculate the diagonal measurement, in feet and inches, needed to square a building based on depth and width of the building. My formula is A= building depth in ft. and B= building width in ft. So A squared + B squared = C squared Calculate the square root of C squared (ft.) and...

Trying to perform an index and match based on partner name. If name is found then look to see if they have services in Agriculture (and then Airway, Smart Building, etc.) from table1[[V1]:[V4]]. If found return partner name. <tbody> Company Agriculture Airway Smart Building Smart City...

I'm working on a file that will have multiple fabs that I'll need to pull data from. The key vertical lookup will be the building name (in column A), and the key horizontal lookup (column header) will be Electric Units. I need to do an INDEX MATCH MATCH since the columns on each tab won't be...

Hello folks: I have the following spreadsheet: <tbody> Where Who Time CardNum Building 2 Entry A Smith, Brian 6:52:00 2498 Building 2 Entry A Smith, Brian 8:33:00 2498 Building 2 Entry A Smith, Brian 7:38:00 2498 Building 2 Entry A Doe, John 11:59:00 41880 Building 2 Entry A...

Hi All, I'm measuring the amount of visits each employee visits one of our internal buildings. I'm attempting to do a fairly easy distinct count based on 3 criteria (date, building and staff ID). The powerpivot pivot table output shows the persons meta data (manager, org, assigned building)...

Hello, Thanks in advance for any help. I never have understood completely what it means by "arguments". I have this formula below that gives me an error saying too many arguments when I initially am building the formula/ What am I doing wrong and what exactly is an argument and how do you...

hi all... how to lookup data with partial match count of number like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid...

Hello, I have been trying to put together a code but I do not find the way to do it. I have transactions with an account number (Column A), the values I want to SUM are in column G. Basically, I need to sum all values in column G which Account Number starts with a 004 (e.g. 004101-200 and...

Hello all, I'm doing some research on creating a custom spreadsheet to receive data from MBS (Metal Building Software). I know very little of where to even start. From what I can tell, it's mainly pulling in text from MBS's shipper and applying it to a spreadsheet. Does anyone have any...

I manage a small business and have been asked to summarize a calendar we have in Excel. Basically we clean buildings every quarter - 1x a year is a full cleaning, 2x are just outside, and 1x sweep/vacuum but not full cleaning --> full and sweep can't be right after each other. We schedule out...

Hi guys, I found myself chasing my own tail at work, and could use some extra input. I'm basically just trying to compare to columns with a condition. There are two variables: - Buildings - 3 to 5 alphanumeric code in a format of 3 or 4 digits, or 3 digits followed by a single letter, or 4...

Hi all, I'm new to the forum and Excel and couldn't find this specific thing on search (or how to word my search), so here goes: I'm trying to figure out how to compute the average date inspection date of a building based off of the inspection date of each asset in a building for example...

Having problems wrapping my head around this one. so my plan is to have a table that will have DATE EMPLOYEE PROJECT# QTY for any day i would have 12 or so employees building panels, some building panels for 2 or 3 projects in a day. what I need to be able to do is total the data by...

I am trying to create a spreadsheet that will create a Job number each time I add a new project. I have 4 different buildings, so I created a drop down list to select the building. Each building will start with a series, like building 1 is 4000, next building is 5000 etc. So each time you...

Hello Everyone, I am hoping someone may be able to help me out. I have a list of building addresses and unique building numbers generated from our system. I have another list of opportunities generated from the same system that contain two building numbers for each opportunity. Each...

I have a database made up of the following fields and queried out with the following. The query works fine but I am having problems getting things to calculate properly in my report StudentID BldgNo - MealStatus = Free or Reduced Ethnicity = African American Has IEP = Y I need my report to...