# bill

1. ### Bill Jelen Channel on YouTube not in Podcast Order

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...
2. ### Power Query 2016: return the latest date in a subset

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...
3. ### If & Or Formula?

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...
4. ### Embedded IF statement placements

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...
5. ### excel sum two conditions column

<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...
6. ### How to create a worksheet from information in another worksheet

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...
7. ### Get closest value for nearest date

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...
8. ### concatinating similair columns

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...
9. ### If, sumif, sumproduct????

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...
10. ### Need Help making a 3D graph

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...
11. ### Another Sorting Question

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...
12. ### Transpose Row with mutiple columns to Column with single row

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...
13. ### Excel formula to search keaywords in multiple columns

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...
14. ### Formula help

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...
15. ### change in order

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...
16. ### Looking to find duration at different levels

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...
17. ### Sumproduct by Month array in a table

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...
18. ### Sorting, Filtering, and Counting Question

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...
19. ### Planning Board

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...
20. ### Import index from different sheets.

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...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...