listed

Group, this is my first time posing a question, so please forgive my ineptitude. I have workbook that has 43 sheets and it's used to calculate accident reconstruction formulas. Sheet 1 is for Coefficient of Friction; Sheet 18 is for Speed Change in a Collision; etc. My goal is to be able to...

I am trying to get this file to be saved in a network drive mapped on my computer. I just want to save it and not close out the file or anything. What I have so far is listed below. I want the file name to be "Bread Reconciliation" + "Whatever date that is listed in cell D1 on Sheet "Bread...

Hi goodmorning, please can you help, I have a spreadsheet where it has peoplesnames and dates but for example there can be the same name on the same date inputtedmany times so Jo Bloggs on 1st April could be listed 10 times, but Ionly want to count the name once and not 10 times please can you...

How do I delete every row of my spreadsheet where the wording "Customer Totals" is listed in Column C of the same row?

I have a spreadsheet with multiple salespeople listed. Each row has a different seller's name and other sales data. It has very private data related to each sellers performance and pay. Is there a way for me to share this file with all sellers listed without going through all the work of...

I have a worksheet like this one. I am looking for a formula that will return the last production number for each month into the table on the right. However, not every date is listed so the formula can not simply look for the last day of the month (e.g. 3/31/19) because that date might not be...

Hi I just want to clear the confusion I have about vba functions vs WorksheetFunction. Please correct me if I am wrong: All VBA functions are listed here: https://www.techonthenet.com/excel/formulas/index_vba.php All excel functions (without vba, like open sheet and type = then function name)...

Hi. I'm trying to report on 100 customers. A select 20 I want to list individually every month, these are not necessarily the top 20 but a select 20 and the other 80 I just want a combined total and not to be listed individually. I can get the select 20 without any trouble but I can't find a way...

I have a list of parts all listed down a row (A). Then I have a date column that shows the last time I purchased that part. The parts are listed multiple times in the list and the last purchase date isn't going to be towards the top of the list. I cant sort the data for various reasons. Is...

I am needing a formula in my revenue column is only added for the Quarter chosen in column A <tbody> Quarter Revenue Q1 500 Q2 250 Q3 350 Q4 100 Q1 2500 </tbody> I want a formula that will extract only the revenue for each time "Q1" is listed. This can not be a pivot table, as it...

Hi, I want to be able to count 0's after the last 1 in my spreadsheet. The number i want counted is listed in my "="-column. Anyone able to assist please? <tbody> A B C D E F G H I J K L M N O P Q R = 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 1...

Here's the setup. I can send the spread sheet over as well. Column A: Listed vertically an infinite amount: Harden, Westbrook, Jokic, George, Irving, Mitchell, Gobert, Walker, Gasol, Faried Column B: Listed vertically an infinite amount: Salary associated with player in column A: 12900, 11000...

I have an old file that is in .xls format. When I open it I receive this message Which is fine because I have the password. When I try to remove the password I go to info to choose protect workbook but there is not a password listed and in fact it allows me to create a new password, if I do...

Hello! Have a question ... Here is my table <tbody> Christmas EggNog Christmas Spaghetti Christmas Meatballs Thanksgiving Turkey Thanksgiving MashedPotatoes Holiday? Options? Thanksgiving <tbody> =IFERROR(INDEX($A$1:$B$5,MATCH(ROW()-ROW($A$8),$A$1:$A$5,0)),"")...

I am trying to create a formula that shows team members that are on PTO for the current week. Each day of the year is listed in tab “Data” in column A and the names are listed for who is covering Category A, Category B, Category C in columns B through D and PTO1, PTO2, PTO3, PTO4 are columns E...

Hey Guys - I'm having issues trying to get some data I need, so wanted to post. Over the past 3 days, I've collected 15 columns of data for ~30,000 systems (one per row) into a single ~90,000 row spreadsheet. below is a Snippet: Note, column D represents the date I captured the data and...

Hi Folks, I am looking for VBA code to find file names listed in a Worksheet in range A2 downward e.g., XYZ.pdf located in the filepath listed in column B2 downwards and then to delete those files (killfile). I have found multiple examples of VBA to kill files e.g., all files in a folder, all...

How can i write out a formula to show: bacon and eggs is yea , but eggs and bacon is no ? Bacon is listed in A1 and.eggs in B1 then eggs is listed in A2 and bacon is listed in B2

Hi, In Row A, let's say I have a either of the listed: Company A Company B Company C Company D In Row B, let's say I have a either of the listed: Product 1 Product 2 Product 3 Product 4 In Row C, I have a bunch of random prices listed. How can I create a formula where I want the average of...

Hi all, hope you can help please!! I have a s/sheet with many columns of categories (types of items sold) that have our stores (listed as store numbers) listed from high to low in each column. I want to create a summary tab for each store, listing their rank in each category. Top is what I...