Lookup With Multiple Criteria: Return The Amount Paid And Full Cost Based On The Person's Name And The Date
I would like a lookup that takes multiple criteria and that is not an array formula! Unfortunately I decided to use array formulae and my spreadsheet went to over 45mb!! Not good. I've searched the forum for an answer to my questions but couldn't find any! I've attached a spreadsheet as an example. The examples I am using have {Sum(IF)} formulae in it (array) and I would like to change those to others that will not increase the file size so much and will not take too long to calculate.
Basically, I would like a lookup that will return me the Amount Paid and Full Cost based on the person's name and the date. the data and the results table are both on separate sheets. It would be nice to bring that file's size back down to less than 4mb!!
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Return Data Based On Lookup Criteria
I have an array in excel, 4 columns: Month, Day, Stock, Price. I dont know the most efficient way to handle arrays. I know i can loop through an entire array to find a specific value, but if i have a large array, this doesnt seem efficient. For example, I would like to find the price in an Array (or Range), when i know the value of two columns. If this were in a database, I would write sql like this: " select Price from TABLE where month = 1 and Day = 3". The result would be 40.21. How can i do this with an array? I have attached a sample spreadsheet with the example mentioned above..
View Replies!
View Related
Multiple IF's And AND Inclusive Formula (all In One Cell) That Would Look At The Above Table And Depending Upon The Price Paid
.............................24............30............36 300014999..........9.00%.......11.00%.....12.00% 1500099999........9.50%.......11.50%.....12.50% 100000249999.....9.00%......11.00%.....13.00% I need an all inclusive formula (all in one cell) that would look at the above table and depending upon the price paid (3000-14999 or 15000-99999 or 100000-249999) and depending upon what monthly term they choose (24, 30, or 36), the appropriate finance charge would be used to calculate a total cost (9-13%). The only way I know to do this is by using IF's and AND's, but there are simply too many arguments and I cannot properly write the formula.
View Replies!
View Related
Multiple Criteria Lookup With Date Range Match
I am trying to create a formula that will lookup multiple criteria within a table, one of those criteria being a date that falls within a certain date range. The purpose of the data is for billing tenants and owners in a building. I have successfully been able to use Index Match to lookup 2 criteria, one of them being a specific date match (see my attachment). However, I need to add a third criteria looks up the date that falls between a specific date range. The concept is to run a query where I enter a Unit (apartment) number into one cell, a Billing Date into another cell and the Type (Owner or Tenant) into a third cell to determine the Name of the person who fits these criteria... Criteria A Lives in Apt XX, Criteria B Who's lease start date and end date is inclusive of the Billing Date that I entered and Criteria C who matches the Type of customer, either Owner or Tenant. I have attached my sample spreadsheet.
View Replies!
View Related
Return Result Based On Multiple Criteria
I have been trying this for hours but to no avail. I have a table with 4 columns headers Name, Amount, Loc and Code The name may look like ABC 1, ABC 2.... The Loc may be in US, GB... and the Code may be AA, BB I need to return a result "Y" if the sum of the amount is > 100 and "N" if the sum of the amount < 100 based on the conditions of the following :if 1) Name is the same entity, such as ABC 1 and ABC 2 and 2) Loc is the same, US..and 3) Code is the same I have attached a sample to illustrates the result
View Replies!
View Related
Return Multiple Results Based On Criteria
Please see the attached sheets. Here's the issue: On sheet "master" I have a list of goals in column A. Each has been assigned to at least one person. Each person will have their own sheet that will capture the goals assigned to them. As an example, see Al's sheet. I am trying to get Excel to look for all of the goals assigned to AL on the Master sheet and list them nicely onto AL's sheet without out blank rows. (and for each, respectively on their own sheet). I could do this with Pivot Tables if the data were displayed differently, but I have been told that I have to display the goal assignments as shown. I could use "x"s instead of their names to mark the assignment and I could combine the "goal-achieved expectations" and "goal #s" columns if it helps. I am not supposed to use filters either. Note: Of course, a goal or an assignment could change on the master sheet, but the assignment is more likely to change. how this done for AL, I can go ahead and create the other sheets.
View Replies!
View Related
Calculate Amount Of Days Paid In Advance And Apply Percent Discount
Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message. give point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount? attached is the start of the assesment question. You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid. Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received: If students pay the course fee less than 7 days prior to the course commencing then they receive no discount. If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%. If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%. If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.
View Replies!
View Related
Return Multiple Values Across Columns And Rows Based On Criteria
I have a table with column headings of product ID Numbers (eg.1111) and row headings of Store number (Eg.1) with data showing the time each product was last sold at that store, I need something to consolidate for each store which Product ID's were sold prior to 5pm and what time they were sold. EG Store 1 1111 16:40 2222 13:00 Store 2 1111 15:05 3333 16:50
View Replies!
View Related
Formula/Function To Return Multiple Values Based On Criteria
I would like to be able to use the Vlookup function to return more then one value as a result of the criteria. I have a cloumn of dates that populates the X axis of a gantt chart with data whilst the Y axis will be populated by a site reference resulting in a program of work, the Y axis data is the result of a vlookup function. My difficulty arises however with multiple sites, for instance where two or three sites will be visited on the same day. The vlookup function will only return the first value it finds in a range to the formulated cell. The result being a missing site(s) from the gantt chart / work program. is it possible to return all values to a cell i.e. site1, site2, site3. using a vlookup or do i need to use another method of doing this?
View Replies!
View Related
Count W/multiple Criteria, Based On Date
using various keywords, and I haven't been able to find a solution that works. It would seem SUMPRODUCT is what I need to use, but thru all the combinations I've tried, I still can't get the syntax right. The problem is: I have dates in col A, and the word "Holiday" in col D. I need to create a formula that counts the number of instances of the word "Holiday" in col D, only where the date in col A is =DATE(2008,1,1))*(A11:A45
View Replies!
View Related
Lookup Multiple Criteria & Sum Result On Multiple Criteria
I am trying to solve a problem. I am currently using this formula = SUMPRODUCT(--(Sheet2!B2:Sheet2!B300="MARKETING"),--(Sheet2!D2:Sheet2!D300="200612"),Sheet2!E2:Sheet2!E300) This formula works for me as it is but I would like to add more months to 200612. I want this to also be 200701 and 200702. In another cell there will be up to 10 months. Is there a way to do a Vlookup or something that will look up these months in another table, rather than keep typing them out in the formula?? Otherwise my formula will be very long. So the info looks like this in excel MARKETING 200612 -10 MARKETING 200701 -25 MARKETING 200708 -50 ECONOMICS 200709 -30 The info goes on and on. The two variables are the MARKETING column and the month column. My problem is that I would like a seperate table that can be the months. So 200612 and 200701 is one table, and 200708 and 200709 is another table. The table changes often so I dont want to mess with the formulas, rather a table.
View Replies!
View Related
Counts The Number Of Hours That This Person Works & Lookup Function
I'm trying to create a work Rota and I'm having a bit of a problem with a certain section. In Worksheet 1 I have the following headings: Cell A - Name Cell B - Monday Cell C - Tuesday Cell D - Wednesday etc Under these headings is each member of staff and the hours they work, IE L (Late), E (Early), SD (Short Day) etc. In the final Column, it counts the number of hours that this person works (Early is 7.5). In Rows 46, there is a section here to work out how many people are working earlys, which is where I have the problem. The hours are worked out by doing a lookup function on the cell that says E, L etc and goes to a CODES sheet and pulls the value of that letter. What I am wanting to do is lookup that Letter, which and look in the cell next to it and count how many people would be on an early etc.
View Replies!
View Related
Formula To Show A Date Range Based On The Amount Shown In Another Cell
Attached is a excel file that has a working formula for tracking cashier variances. I edited out names etc. I added a new cell called Track Back on the employee search sheet. What I want to do is only show variances for the amount of days back selected in the Track Back cell. For example if I select the last 30 days, only the last 30 days would show up below in the sheet. I am not sure if this is even possible based on the forumla that is already on the sheet. I couldn't figure out a way of doing it. But there are a lot of people on here much better with excel than me
View Replies!
View Related
Create A Formula To Pull The Person's Name And The Avg Number Of Cartons
I am trying to create a formula to pull the person's name and the avg number of cartons sorted for the month from this spreadsheet. I've attached a sample of the spreadsheet I created, you will see at the bottom I would like to see the person that had the highest avg for the month and the person with the lowest avg for the month. This is just a simple spreadsheet to track productivity of my sortation employees.
View Replies!
View Related
Lookup 2 Criteria And Return Info In Specific Column
I've got a database that is sorted by date... I need a formula that will look for 2 criteria and once it finds those 2 matching criteria, I need it to return the information on that line that's in column 6, let's say. so in one column I have the date, the next column I have the sales persons name, 4 columns over I have their order number. In cell a1 of worksheet 1, I have a drop down ready that has all my sales persons listed. In cell a2 I will manually enter the date that I need to reference. I need the formula to then look for cell a1 and a2 in worksheet 2 where I have my spreadsheet with the info I mentioned above, match that criterium in worksheet 2, and return the info in column 6.
View Replies!
View Related
Lookup Multiple Same Value And Return Multiple Corresponding Value In Ascending Order
I have a problem with the formula that look up multiple records with the same values and return multiple corresponding values in ascending order. I am using Excel 2003 and it is a bit complicated to explain so I have attached a sample spreadsheet to show what I mean. What I want was after I have sorted the occurrence value in column E based on column B and I want to correspond the Rank in column D based on column A in ascending order for the same occurrence value in column E. Eg: There is two occurrences for number 1 at E3 and E4, and three occurrences for number 2 at E5, E6 and E7 in column E. Then the Rank for the first occurrence for number 1 in D3 should be ranking 6 and the second occurrence for number 1 in D4 should be ranking 7, so the Rank for the first occurrence for number 2 in D5 should be ranking 3, D6 should be ranking 4 and D7 should be ranking 9 based on column A and B, etc.
View Replies!
View Related
Sum By Date Paid
I am trying to sum rows based on unusual criteria: i.e. A table of date c2:t9 contains details of expenditure for 16 periods for insurance and motor expenses. i want to convert this to a cashflow format and reflect when the item is actually paid, so if it is paid in february, march, etc (given in the original table) I want to add the totals in the months preceding the set date. also, if the criteria is a number <12 then i want to add up the preceding amounts if the period number is a factor of that number e.g - criteria is 3, then i want to add rows 1-3 and put in period 3, 4-6 and put in period 6.
View Replies!
View Related
Lookup And Return Multiple
I have a spreadsheet similiar to the below: COLUMN A.....COLUMN B Person 1.......Process 1 Person 1.......Process 1 Person 1.......Process 2 Person 1.......Process 1 Person 1.......Process 2 Person 1.......Process 3 Person 2.......Process 1 Person 2.......Process 4 Person 2.......Process 1 and so on. In the list, the "People" aren't neccessarily in order, for example, later in the list, Person 1 appears again. There are a total of 10 processes, and any person can do any number of each. What I ideally want is in Columns D, E, and F, is something like the following: COLUMN D.....COLUMN E....COLUMN F Person 1...........3.............Process 1 Person 1...........2.............Process 2 Person 1...........1.............Process 3 Person 2...........2.............Process 1 so a summary of the main data, showing how many each process each person has got. I have, and failed miserably, getting arrays to work but that might just be down to my own incompetence. I have researched into Countif's and Lookups, but it's not quite working. The data in columns D, E, and F needs to be fairly compact so ideally I wouldnt want any spare rows between the end of the summary data about Person 1 and the start of Person's 2 details.
View Replies!
View Related
Multiple Criteria Lookup ..?
I'm trying to figure a formula that provides a numerical value when certain criteria are met across a range of cells. The criteria are numerous though and here is where I'm having trouble. For example, the formula needs to look at Cell A5, then at a range of cells (C5,G5, E5, I5) and depending on the value of those cells provide a predetermine result in Cell K5. For example, IF (A5 = 'A', and C5=1 or G5=1 or E5=1 or I5 = 1, then P5 must = 15), or if (A5 = 'A', and C5 or G5 or E5 or I5 = 2, then P5 must = 10), or if (A5 = A, and either C5 or G5 or E5 or I5 = 3, then P5 must = 6), or if (A5 = A, and either C5 or G5 or E5 or I5 = 4 then P5 must = 2), or if (A5 = A, and C5 or G5 or E5 or I5 = 5, then P5 must = 1)
.this needs to be duplicated for a list of possiblities.
View Replies!
View Related
To Get The Most Recently Paid EMI In Tune With The Current Date.
Most Recent Paid EMI Date: I need to get the Most Recently paid EMI in the List it should be in tune with the TODAY() as well as the PAID one indicated by "X" in Column F.. Next EMI DATE: This would be the NEXT EMI date as the name suggests after the Most recent paid EMI
In this case 14-Feb-09 Date to Replenish: This date would be when the Amount in the Account has got reduced indicated by "X" in column E...In this case 10-May-09.
View Replies!
View Related
Lookup With Multiple Result Return
I have an excel worksheet that consists of 4 tabs. Each tabs has approximately 60,000 lines of data. The data consists of user id's and menus that correspond to the user id. There are 131 user id's in total. I would like to be able to return all the menus for one of the user id's. If we need to start with one tab and work from there, that's fine.
View Replies!
View Related
Lookup To Return Multiple Values
Is there a way to use a lookup formula to return all values of a given text, not just the value of the first listing of the text. In an attempt to clarify my already confusing request, if A5 on "worksheet1" is "Land" I want E5 on "worksheet1" to return the summation of values assigned to "Land" "worksheet2" "column B" any time "Land" appears on "Worksheet2" "Column A".
View Replies!
View Related
Lookup Based On 2 Criteria
I need to take a value from an adjacent cell and automatically enter that value in a specific cell in table on a second worksheet. The cell must match two criteria specified in the previous two ceels to the value. The table is made up of dates and colours, it seems simple in my head but I'm not sure where to start, i would like to use a macro so when a specific key is pressed the information is automatically entered into the relevant cell.
View Replies!
View Related
Lookup Value Based On Two Criteria
I have two pivot tables (for sales and purchases) with three columns each, ie: company 1, company 2 and amount I need to reconcile that for the internal purchases and sales the sale value is the same as the purchase. So in first pivot table (purchases) I have one row with internal transactions where company 1 = AZS, company 2 =YDR, value 100 In second pivot table (sales) I have one row with internal transactions company 1= YDR, company 2 = AZS, value 95 I would like to develop a macro that would check automatically the combinations of companies and find out if there are differences between sales and purchase. So in the example it should show that there is 5 usd more in purchases. Hopefully normally is zero
View Replies!
View Related
Return All Data Based On Lookup
How to return all possible values based on a single lookup ( or another condition / macro ) I have a table in B5:E100 In A1 I have a value I need to look in B5:B100 for the value in A1 then place the contents of B:E for those cells in G5:J5 downwards
View Replies!
View Related
Return Text Based On Lookup Value
I have a database of customers that are all sorted by a customer number. I have a form that has a number of fields that display customer info. When I use a blank of this form and put the customer number in it's correct field, all the other info fields do a vlookup on the customer number in the database file and return the info, such as phone numbers, name, address, etc. Here's my question; How can I check for a blank (using ISBLANK, I assume) to check to see if the customer number exists in our database and, if it's NOT blank, operate on it with the following example which is used to return their insurance expiration date. =IF((VLOOKUP(B9,'[carrier list.xls]Sheet1'!$A$2:$P$1276,3,FALSE))<TODAY(),"EXPIRED",VLOOKUP(B9,'[carrier list.xls]Sheet1'!$A$2:$P$1276,3,FALSE)) I realize that this may be a sledgehammer approach and that Access is probably a better tool, but my company has not shelled out the $$ for Access...yet.
View Replies!
View Related
LOOKUP ONE CRITERIA IN MULTIPLE COLUMNS
I am trying to run a lookup on a rather large table. Column A Column B Column C Column D Column E Column F Postal code City Province Postal code City Province I am trying to look up the City and Province based on the Postal code and can't figure out how to do this. There are too many Postal codes to fit them all in Column A, I have tried V Lookup, Index Match and can't get it to work.
View Replies!
View Related
Static Multiple Criteria Lookup
i need to track tyres, i'll have to use the Serial Nos. of the tyres inscribed on them. What i require is to lookup the serial no. from Purchase/issue sheet to my Maintenance sheet. To do that there'll be 3 criterion to match to get the correct Serial No. In my Purchase sheet suppose if a purchase a tyre and issue it to some vehicle on 11th September, i'll have its first inspection for maintenance after mebbe a month (no fixed intervals). So if i check on 10th October the lookup should actually find the greatest date lesser than the inspection date and keep it to that. I know that the lookup function would get the last unit in case of duplicate entries but that becomes dynamic and the serial no. would change once theres another entry matching the 3 criteria. And dat would mess up my previous record.
View Replies!
View Related
Use IF/Lookup Function In Multiple Criteria
I have table product that include (wide 1,wide 2,thick 1,thick 2,long 1,long 2,Price) And I have table transaction than have wide, thick, long and price) I want that price in table transaction fill automaticly from table product where ( wide between wide 1 and wide 2 ) and ( thick between thick 1 and thick 2 ) and ( long between long 1 and long 2 ) excelformula.gif pricing.xls
View Replies!
View Related
Lookup With Multiple Criteria...sumproduct
Attached is my sample workbook. There would normally be 600+ employees with multiple rows per employee. I would like Cell O3 in the Premium Calculation Worksheet to look at the Premium Contribution Report, and if Row A contains the employee number (A3) AND row C contains "H&D" I would like it to sum row E. I included the sumproduct formula I tried to put together but I'm getting an error, so I'm not sure what I've done wrong. The reason I have it referencing "O2" instead of just inputting "H&D" is that O2 could be any number of plans - I have multiple rows with different plans and I need it to pull in all the data.
View Replies!
View Related
Multiple Criteria Lookup Returns Name
I'm getting cross-eyed from trying to find the source of the error and not having any success. I've successfully used this approach many times, but for some reason I'm getting an error I can't pin down. The problem: INDEX-MATCH lookup formula returns # NAME error. Formula: =INDEX(Data,MATCH(H8,Date,0),MATCH($I$7,Line,0),MATCH("FPY",Hdngs,0)). I've done my best to verify the named ranges and cell references are correct and have stepped through the help file on the "potential source of the error", including going to Tools >Options and making sure "Accept Labels in Formulas" is checked, as well as having read a number of other posts.
View Replies!
View Related
Multiple Criteria Lookup For Smallest Value
I have a workbook with 4 sheets with Carrier rates based upon weight breaks and cities. I.E. Carrier 1 services City 1 @ 1.30 per LB for 0 -100LBS and 1.55 for 101 - 199LBS. What I need is a forumla so that someone can input the city and weight on sheet 1 and it will search the 4 sheets and return the cheapest Carrier in the event that there is two carriers with the same rate it would return both. It would also need to return the rate for that city and weight. For example User inputs "City 1" "112 LBS" formula searches the 4 carrier sheets and returns values "Carrier 1" & "1.55" as this is the cheapest carrier and the rate they charge per LB for this city.
View Replies!
View Related
Lookup Values- With Multiple Criteria
I want to lookup values from one rawdata worksheet and have values appear on another sheet, but using 3 lookup values as the criteria. I cannot do this function with Vlookup as it only takes one criteria. I have looked for similar threads in this forum and came across an Index/Match function, but I cannot get it to work. I am attaching file. The data is in the 'rawdata' worksheet. I want values to appear in 'Input' worksheet, grey area using the 3 criterias (Dept number, GL number, and Seg code number).
View Replies!
View Related
Multiple Criteria Lookup Between Workbooks
My workbook is tracking how many products have been sold and to whom. Customer Market Apples Oranges etc (10 products) POSTING xyz South 100 xxx South East 600 I have a second workbook that works out how much it costs us to send the goods and this is a matrix based on where our customer is and which produce they have purchased. South Apples Oranges Pear etc South East $x $y $z North etc North West etc I would like to write a formula under the POST column that takes into account: The Market. The Produce type (the column heading) based which cell contains a value i.e using above Row 3 criteria would be Market = South and Produce = Apples. These two pieces of information are then to be used to go to the workbook containing our postage costs and picks up the relevant cost for Apples in the South region.
View Replies!
View Related
Macro For Filtering Spread Sheet By Date And Specific Person
I am fairly new to macros and I am currently working on a project where I would like to create a 2 buttons which will filter by date and by owner. The spread sheet I have is fairly large and is added to weekly. I have two objectives that I am trying to reach: First I need to filter for all past due task items from the Thursday of the week I am working in back and for a specific person (owner) by the finish date Second I need to filter for upcoming tasks one week out for a specific person (owner). The objective of this is so that on any given day a user can find any upcoming tasks that are due one week out. If this is not an option. My thought was to create an input box where the user can input the date and the information on the spread sheet will pull all past due items or upcoming tasks. These two items need to pull seperatly not together. I know I can create a macro by autofiltering by columns however I am trying to avoid having to go in and change the date each week. Start date is column E Finish date is column F Owner is column L
View Replies!
View Related
Lookup Multiple Conditions To Return One Result
I am preparing an "automated" order form. I have a list of products (ten) in a pull down list, a list of options (3) in a pull down list and a list of the pricing. So, If PRODUCT_A with OPTION_A, then PRICE = $X. If PRODUCT_A with OPTION_B, then PRICE = $Y. If PRODUCT_B with OPTION_C, then PRICE = $Z. etc. I want the user to select the product, then the option, and have the correct price "pre-fill" the cell.
View Replies!
View Related
VLOOKUP To Return Multiple Cells Of Same Lookup Value
I am trying to create an automated receipt for a list of artists. I have given the artist an individual reference so I am doing a VLOOKUP to return description/price value etc but I can only get it to return the initial value and I have approx 10-15 works under each reference. Maybe VLOOKUP is the wrong formula to use.. I have attached the file.
View Replies!
View Related
Lookup & Return Multiple Items
I am trying to make a search form in Excel 2003 where I can lookup data for a specific value which may have multiple rows. I have several columns, column A Tracking Number, B Order number, C Item Number, etc. For example; Order number S6001 has three item numbers on rows 1,2,and 3. I can get the data on row 1 using the basic "LOOKUP" function but not rows 2 and 3. How do I have all of the line items (rows) returned for that order number.
View Replies!
View Related
Lookup & Return Multiple Occurrences
In Sheet1 are unique VM entries (Column A) which have a Group (Column B), Time (Column C) and a Reference (Column D) which can be same for other VM entries. In Sheet2 are the unique Reference Entries (Column A) which need Group (Column B) and Time (Column C) entries populated from Sheet 1. Multiple occureneces need to go in one cell, I realise this is not the best idea, but for this purpose they need to be and seperated by a comma or semi-colon. In B2 I've used this formula: =INDEX(Sheet1!A1:D11,MATCH(A2,Sheet1!D1:D11,0),2) Which partly works, but only returns the first occurrence of H1 on Sheet1. I need all occurrences (i.e G1;G4;G8) returning for B2. I can only think that some VBA script may be needed but I'm not really an expert in this area. In the full spreadsheet there are hundreds of rows and multiple entries, where Group and Time need to be populated on the second sheet
View Replies!
View Related
Lookup Multiply Based On Certain Criteria
I have two worksheets, one is setup with a part number only and the months Jan-Dec. The other worksheet has those same part numbers, but it also has the quantity and the months Jan-Dec. I need to do a lookup to find the part number, multiply it by the quantity on that given line, and then multiply it by the quantity in the month. I will show you how my worksheets are setup: Worksheet1: Qty P/N Jan 1 123456 100 1 123456 100 2 456789 50 4 123456 25 3 345678 500 1 456789 75 Worksheet2: P/N Jan 123456 Sum of ALL Jan Demand * the Quantity of each item 345678 Sum of ALL Jan Demand * the Quantity of each item 456789 Sum of ALL Jan Demand * the Quantity of each item
View Replies!
View Related
Result Based On Two Criteria Lookup
See the attached file. I think index and match may help me having done a search several times in these forums, but having been trying to do this for several hours I am just struggling to understand each part of the formula unfortunately. I have a list of data (cellsA1 to C33) which I need to use as my source for the information that is displayed in cell I2 based on the two selections made in cells F2 and G2. I can't use filter and data sort in this situation - I am creating a spreadsheet for someone who truly knows nothing about excel, so I need this to be as simple as pointing and clicking at cells F2 and G2 and the formula doing all other work. Is it possible to do what I am asking for (hopefully the fact that peoples' names are repeated and months are repeated won't cause a problem?
View Replies!
View Related
|
TRACKER
