I am adding values together from 2 different sheets based on 1. date (in its own column) AND 2. if the description contains "AP" or "CD" (In another column) to populate on a summary tab.
I have tried the following formulas:
For my values containing AP or CD
1. =SUMPRODUCT(('GL...
Please help me below. Hope someone can help me,
I have two workbook like below:
Workbook 1 As below:
<colgroup><col width="72" style="width: 54pt;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;" span="5"> <col width="112" style="width: 84pt...
Greetings fellow pivot table practitioners,
I'm trying to link two sets of data. Samples are listed below. I'd like to figure out a formula that populates the "Status" and "Day Status Began" in the top table based on the data in the second table.
EX: On 21 Jan 2015, Scott submitted a report...
Hi all,
Have had so much help on this forum in the past, and would love for some help and support again! :)
I really need help to find a solution for what I need to do: I will try to explain it in the best possible way below...
SHEET 1
______Colm F_____________________Colm N
Row 6_COMPLETE...
Hi all
I have a pivot table that generates a list of staff that have completed timesheets for eaqch day of the month and the hours booked. The number of entries on each day will vary accoring to whether a timesheet has data on it or not - so for example, on one paricular daythere may be 3...
I have a huge spreadsheet of contact. I am trying to scrub out all the email address that contain an email extensions on my exclusion list. For example @gmail.com and I am trying to use a wildcard character to find all the email address within my table that cannot be contacted. I am unable to...
I am having trouble trying to workout how to do the below.
<tbody>
W/E
12/04/2014
19/04/2014
26/04/2014
03/05/2014
10/05/2014
17/05/2014
24/05/2014
Rev.
200
200
200
200
200
200
200
Cost.
100
100
100
100
100
100
100
</tbody>
I would like to combine a LOOKUP and SUM to say the following...
Greetings!
I have a conundrum regarding a bit of data validation that I'm developing. The purpose is to determine if, on a particular row of data, a specific text string exists. The text string could be found in any column past the first. For example:
<tbody>
Name
variable 1
variable 2...
Hello,
I have a column of data with: Last name,Company Name-First Name
I wanted to create a lookup formula to return only the company name in the adjacent cell.
Does anyone know how I would do this?
Thank you
Environment: I am using Excel 2003 and self taught in excel and VBA. I am very new to VBA and if pointed in the right direction will learn a topic. However I need direction
I have a mockup of a Call Center floor seating diagram called "Seating Chart" Workbook and Spreadsheet. "Seating Chart"...
I am working on an Excel spreadsheet to make sure that everything that has to happen to get a new hire enrolled in benefits happens on time. Our staff are eligible for benefits on the first day of the month after 30 days of employment. (i.e. if the hire date was June 19, 2013 the staff member is...
I have an excel spreadsheet that has 3 Columns: 1) City 2) State 3) Population all on sheet 1. On Sheet 2 cell B1 I want to be able to select the state and display all cities within that state & their population. I would like to have a formula that accomplishes this and it needs to be...
I need to pull a product ID based on if the number of users and a specific product are in a range of values. I tried a few formulas with no luck.
<COLGROUP><COL style="WIDTH: 48pt" span=9 width=64><TBODY>
ID
Users
PROD ID
ID
USER LOW
USER HIGH
PROD ID
A
1
A
1
100
AB1
A
100
A
101...
Hi!
I have a part number that I need to look in a range of value in order to have the manufacturing program. The Range I have is like this:
Part 1 to Part 5000 is for chevrolet
Part 5001 to Part 5925 is for Dodge
Part 5926 to part 6000 is for JEEP
My list have for example part 4500...
Dear All,
I have two tables, in table 1 i have a statement of more than one customers combined in sequential order, in table 2 i have customer numbers vertically placed and dates horizontally placed. i want to use a lookup function which may extract day end balance in front of each account...
Hello all,
I am relatively new to the VB code for Excel macro and wanted to get your advise on the following macro..
'=== CODE START ===
Sub c_SLCodeThisWk()
Dim t As Long
For t = 2 To 100
Range("AR" & t).Formula =...
Hi,
I need to be able to find multiple values where the same thing occurs. This also needs to be able to use subtotal so that if I filter it only returns the names shown. Poor English so I'll use this table to explain:
I need to fins any pupils name where they have particular values. So for...
Hello gracious gurus,
I need assistance with dependent list boxes. I have reviewed about 7+ videos and cannot find my answer.
I need a formula that will show a List Box based on formula. For example, if I select model "CT4-3/8" then, I want to have the "LB_TB_Fifteen_In " List Box choices...
Hi Guys,
I have a problem I cant find a solution too.
I have a table of stock codes with corresponding price list (exported from Sage), but on another sheet I would like ot lookup an abbreviated code and return the corresponding price. This means searching cells which contain a particular 4...
Looking for a better way to substitute correct words for incomplete spellings in a list. The following works, but if a word is not exactly like I have in the lookup, the replacement fails. In the next column over from C34 I have...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.