bill

I have a Roku, an iPad and an iPhone and I am subscribed to the Bill Jelen channel. While I am very familiar with Excel, I want to start at the first one and go through each one. When I look at the list of videos many are not in order. For example, the first one I see is 2188 and then 2187...

I have tracking data that contains many dates for the same person. How can records be cleaned up so that it shows only the latest date for each person. Here is an example of the data: <tbody> Date Personnel Sold 2017-11-11 Bill 87 2017-11-11 Susan 73 2017-11-11 Susan -5 2017-11-09...

Greetings! I need a formula in column D, that reports Yes, if the Vehicle Year is older than 12 years, or KMs are greater than 333,333. And if Vehicle Year is "" then "". Thank you in advance. <tbody> A B C D 1 Name Vehicle Year KMs Meets Washout Criteria 3 Sue 2015...

Hi all! I am writing a report that is calculating deferred/accrued revenue to be accounted for each month. To determine how many days are allowed for deferral I have a column that tells me how many days are in each period. There are 12 buckets as there are 12 billing periods. To look up to...

<colgroup><col span="4"><col></colgroup><tbody> A B C D 1 bill no rate amount required sum 2 100 12 300 3 100 12 245 4 100 5 334 5 103 12 456 6 103 5 166 7 105 5 321 8 105 5 766 9 105 12 776 10 105 12 978 </tbody> <colgroup><col...

Hello. I Have a question of how to do an excel worksheet. I have a names of employees. Each employee takes between 1- 3 weeks of vacation. I have the worksheet completed that tell me what weeks each employee has, however, how can i make a new worksheet (using the completed worksheet info), to...

From the below. worksheet1 : In worksheet1 "duty" column. I need to find out what duty "worker" last had during work_order_date. Bill on work_order_date 08/01/2017 & 08/05/2017 should report back as "welder" because he was not yet a manager until 8/15/2017. worksheet1 Bill work_order_date...

Hi, I am using Excel 2003 on Windows 7. I have data like the below table, where there is a name in each of Columns B,C,D,E,F and I have concatenated columns B,C,D,E,F into column A. I included this data into a pivot table and what I am getting is 2 rows of data in the pivot table. 1 for...

Good morning and thanks in advance for your help. I am trying to figure out what function to use and how to write a formula that will tell me If Bill Bob worked during week 1, and his name appears on the list of those that worked (sheet1!A:A), and that week has four 8 hour days as indicated in...

Hi Guys, Need help building a graph, here is my sample Data NAME | Region Joe | WEST Joe | WEST Joe | EAST Bill | EAST Bill | EUROPE Bill | Mid-West now I want a Graph that would show the total number on the Y axis and...

I have the following code which starts off by pasting into cells A1 through B6 the following data. All of the data pasted into column "A" is numeric. I ran the macro recorder and then copied and pasted that into the bottom of my code. When it gets to the line...

Hi, I am trying to convert a table in the following way. Is there a way to realise this using a make table query? <colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> Name WK1 WK2 WK3 WK4 WK5 WK6 Tom 100 100 100 100 100 100 Bill 25 25...

Hello, I need your help please, I need to find a formula to search in multiple columns if the cell contains specifics key words if it is the case I need to flag the result = hopitality. <colgroup><col></colgroup><tbody> Key words Fairmont Raffles Sofitel Rixos Mc Gallery Gallery...

Hi I have a data column that shows a series of level 1 and level 2 tags. the data presents as L1 space and then the name of the level 1 tag then a comma space then L2 space and the name of the level 2 tag. See examples below I urgently need a formula that returns the L1 tag name and a second...

Hi There This is probably a very simple thing, but I am no excel expert and am wondering if someone could suggest a formula. I have an employee schedule. Some employees have set rotations of shifts and others do not. I have assigned them all a number to start with based on the lines that they...

Hi, My data is as follows: <tbody> Name Date Level John 1/1/2015 1 John 1/23/2015 2 John 1/30/2015 2 John 2/5/2015 3 Bill 1/12/2015 1 Bill 1/15/2015 2 </tbody> I'm trying to easily see how long each person was at a given level. For example, from the above, I see John was at...

Hi y'all! I have a table named: 'TRANSACTIONS_ALL'. I have the column 'date', formatted as mm/dd/yyyy. I have the column "MONTH", which pulls the month of the date from the date column out and represents it as a number. I have the column 'TYPE', classifying row items as "funds in", "funds...

Hi all, I recently started using Excel and have been trying to solve a problem involve sorting and counting. I'm sure it's been encountered many times before, but am having trouble figuring it out. I tried searching for answers on the forums, but was having trouble putting my question into...

Hi there, I am some what of an amateur excel user, but i am trying to design a packaging planning board for my manufacturing facility. Basically i am trying to create a front page that my customer relationship managers can use to create a bill of material, bulk issue and reconciliation...

Hi everyone, first time on this forum for me. I'm definitely sure that you will be able to help me! So I'm doing kind of a billing template and I want to make it so easy as possible. Minimum effort to get the bill done with other words. The thing is that I have alot of customers, that comes back...