Get instant live Excel expert help to learn how to find range in Excel

I have a master sheet that contains 5 columns: name, net assets, initials of advisor, age, and revenue. I have several other sheets each one specific to the advisor initials. On each sheet there are 7 columns with a certain net asset range as the header. Im trying to create drop down lists for each column that will bring over the names that correspond to that net asset range and advisor initials. How can I do this?

Hi there, so the other day a very nice chap helped me with the attached report generation. I may of over complicated matters by asking for the report row to start a new "row" at drop 11. I have reviewed this and it makes thing very complicated. please could someone or same chap look into simplifying the code so it just produces the individual routes, each route to be 1 row not separated at drop 11. I have issued more notes in tab (introduction). The range of deliveries varies from day to day so a dynamic range is needed in all formulas on sheet1. It would also be great to if the consolidation i have tried adapting works prior to the report generating. this needs to consolidate like deliveries of that route group and summizing the volumes K and J into the first match of that duplicated delivery location. I understand i am asking alot i am willing to pay for repeat sessions. your help in simplifying and explaining the script that generates the report would be very much appreciated. or looking into the consolidation. it up to you. cheers and kind regards Currently some formula are not working due to the requirement of dynamic range

Hi there, the other day a very nice chap helped me with the attached report generation. I may of over complicated matters by asking for the report row to start a new "row" at drop 11. I have reviewed this and it makes things overly complicated. please could you add in simplifying the code so it just produces the individual routes, each route to be 1 row not separated at drop 11. I have issued more notes in tab (introduction). The range of deliveries varies from day to day so a dynamic range is needed in all formulas on sheet1. I understand i am asking alot i am willing to pay for repeat sessions. your help in simplifying and explaining the script that generates the report would be very much appreciated. or looking into the consolidation. it up to you. cheers and kind regards Currently some formula are not working due to the requirement of dynamic range

My dependent data validation formula works only for the first row. the formula I'm using is: =OFFSET(Heading Cell, MATCH(cell, picklist range,0),0, COUNTIF(picklist range, cell))

Hi, I have a master sheet with 5 columns: Client Name, Net Assets, Advisor Initials, Age, and Revenue. I also have a second sheet in which I am trying to pull client names into drop down lists specific for the advisor and age range.

Populate cell B10 with the number of courses whose duration is known, based on the information in the range B2:B9, using the proper formula with cell references (B1 etc). What is the formula please?

hello, i have a range of numbers from 0 to 1300. I m trying to get a formula so depending where the range lands it will = another range of numbers from 4 to 13

Do you know how to set ranges in excel? For example: =IF(a1=a2=a3, sum(b1:b3),0)? It could be a1-a3 or it could be through a5 or further. I can't seem too define the range based on like values

"I want KPI ( from Sheet2-A Column) on ""M"" column, with first criteria Review ID (A) & 2nd Criteria will be Source Name (i), where Criteria range and KPI Score on Source KPI."

I am trying to define a range in column S based on column M, pull the largest value, add $2.50, and enter it into a new column.