# track

1. ### Index formula, Multiple Criteria, Two Different Worksheets

Hello, I am trying to figure out a formula the will copy the 1's in the Export Sheet C2:F6 and place them in the Track Sheet in cells C2:F6. The Export Sheet contains the data and the Track Sheet should match A2, B2, and C1 with the same cells in the Export Sheet to get the correct cell with the...
2. ### SUMIFS with duplicated column names

Hi there, Please see the attached Sample on dropbox link. I have a Master sheet that I want to track the total of events that occur each week for a sports team. https://www.dropbox.com/s/mpsxrh3couwu2lh/Sample.xlsx?dl=0 On the Engine sheet this will track the possible events each week and...
3. ### Request Users name when saving workbook

Hi all. 1st foray into Excel and I'm stuck. I have a basic workbook which allows users to enter holiday requests and I need to track the user who is making the changes. Unfortunately this is done on shared PC's so i cant use the UserName associated with the PC./Excel which is where I've come...
4. ### Linking two columns so time changes are mirrored

Hi All! I am creating an excel spreadsheet for an event There are two time columns side by side in the same sheet. One shows ‘time code’ (like what is used for film) and the other shows ‘track time’ (which shows how long that particular track has been going) So for example, for the third...
5. ### Need an formula to track the number of draws a value follows another value.

R1 R F R 2 4 F 1 0 The formula for above format. =IFERROR(MATCH(1,(SKIPSUMS!\$AG\$21:\$AG\$6631=\$A17)*(SKIPSUMS!\$AG\$22:\$AG\$6630=B16),0)-1,"") I would like the formula to be in this format. <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
6. ### Track Correspondence

I'm looking for a way to track correspondence (email or Direct mailing) Example that I would like on 12/1/17 Mailed to "David K", "Wanda S", "Bridgett C", "Dack T", "Hannah H".....etc..... on 12/2/17 Mailed to "David K", "Steve M", "Chris P", "Ryan S", "Hannah H" The names...
7. ### Volume tracking

Hi, I am trying to create a way to track volumes for orders received for multiple products against orders completed on a daily basis. I do not need to track the order details, just the overall number received/completed for a day. I currently have 3 sheets - 1. Orders received (table with list...
8. ### Workbook constantly wants to calculate

This isn't a problem, just curiosity. I've got a reasonably large Excel forecast model (10Mb). I recently rebuilt the model to FAST standards, so it now uses a ton of SUMIFS over 1200 cell ranges and these feed a lot of other sheets. Calculation is Automatic. At bottom left, where it says...
9. ### MATCH first 7 of one cell with first 7 of another cell

I'm trying to figure out how to properly input a formula that will match the first 7 characters of C2, with the first 7 characters of A2. =IF(ISNUMBER(MATCH(LEFT(C2,7..........),true,false) Not sure if I'm on the right track. I'm confused with using "ISNUMBER" because I'm not looking for a...
10. ### How to calculate summary table for my production

Hi, I'm working on the production of a Microsoft Office e-learning course. My Excel file contains a worksheet where I track progress for each individual course module. The 4 production stages are (simplified): text - screenshots - voice-over and animation Whenever a step is completed I...
11. ### Calculating W/L - multiple tracks

Hi, all, Trying to find a way to explain what I need so bear with me. My daughter and I have setup 2 marble tracks. We have 5 sets of colors marbles and we want to have mini tournaments (seasons) racing the 5 different colors over 2 tracks. It is very easy to calculate the W/L as a total...
12. ### Track Changes History Sheet

Quick Question, In excel 2016, I want to track all my changes but when i make a change on the workbook, i want to record the reason for the change on the history sheet. I wanted to do this by adding another column in the history sheet tab but the sheet is protected. Is there any possible way...
13. ### Advanced If statements with Calculations

Good afternoon, I am trying to generate a score based on responses with values from 1-3. For example: I have three categories: on track, off track, and N/A. I would like to generate an "IF" statement where "on track"=3, "off track"=1 and "N/A"=0. This will be pulling from a pick list from...
14. ### How to use Vlookup and IF function together in a table. Is there an alternative method?

I'm trying to make a table that determines the price of a track depending on the length of the track and the track type. What I want is to have a table that does the following: Column A= Track Type (Ceiling fix and Face fix) Column B = Track Length Column C = Track Price If track type...
15. ### mail merge - email list to test if emails are good?

Hi All, not sure this is the right place but...I have a bunch of very old email addresses that I have entered into a data base for a local non-profit. Most of the emails are probably bad but I can't tell. I have Gmail and or Yahoo but neither of them have any kind of feed back to let me know if...
16. ### Tying an excel database together with a search engine

I have a large number of receivables in a spreadsheet that I am trying to locate. I can use relative reference to work down the spreadsheet one record at a time. Would anyone know how to take the active cell, populate a search engine, and auto-populate the name into it and conduct a search. This...
17. ### Calendar Tracking Set Up HELP!

Good Afternoon, I am trying to make the calendar we use in excel to track orders more user friendly. First I would like to click on a cell and have a sub window to pop up asking for the below Customer (Text) PO# (Text) Time (Text) Assay (Drop down) Order# (Number) With those answers I’d like...
18. ### Track changes of a column's cells

Hi there, I'm using Excel 2013. I was looking up other questions, but simply couldn't adjust those codes to my case. Issue: Column 'BN' contains dates. I would like these dates to be updated automatically whenever I modify a cell in column 'BP'. Format should be yyyy.mm.dd Additional info...
19. ### Data source dates sheet

I have many sources of data for our database and would like to track the dates we receive these sources. Initially the Excel source is renamed and copied to our network via an Access VBA script, which checks for the latest source. From here, once it finds a source it runs an Excel macro which...
20. ### Linking text multiple cells from one sheet to another sheet's individual cell using Concatenate.

Hi So I have the following: Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting There is another tab in the excel. I don't have it on me. Let's say I have a tab named "Track" and the picture above is Tab named "Time." In the Track tab, I have a column called "description of...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...