Search results

Hi there, Would be most appreciative if someone could assist , or tell me its not possible to do. My company is undergoing a restructure and wants to allocate columns to rows of data that are scaling out a number of requirements. (I have attached the sample file- please see columns H through...

hi apolgies i posted yesterday i have data by date , by category and by location. i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level. and then to sum up to a YTD...

hi i have data by date , by category and by location. i am hoping for help with being able to just return the daily data in the front tab based on a date drop down (see data tab), by category type and location and also at a total level. and then to sum up to a YTD position ( see data is split...

wow, thankyou so very much to both of you !! i have more if you are ok to help me with them! i will post them up today. thankyou so so much

Hi , thankyou, yes understand. can you have a look if you dont mind at what i have done for columns D&F in the table - its not returning anything not sure why- sorry

Hello there hoping someone can help me with the formulas for this please. i have attached a workbook for you. I have a data tab which has columns for Dept, Activity, Position Status, FTE and Gross S&W one column for each the output tab, i wish to split out both the Dept and Activity in the...

thankyou so much

Hello hoping someone can help! i have a set of data with employee ages that i need to create a formula to define what demographic they fit into (ie baby boomer, gen x etc) i am not sure just how to do it please see attached example first tab is the employee list, second tab is the demographic...

thanks Peter. all i am doing is trying to learn.i am most certainly not an expert just been tasked with something i have been wrestling with trying to do based on the data i have. thanks for your help its greatly appreciated.

Hello there Hoping someone can help me with SUMIFS for multiple criteria. I have added a workbook attached. I am not sure how to write the formula. In the first tab is the data to be returned (by team, classification ,FTE and $$) in the second tab is the data any help would be greatly...

Hi Hui yes have got your email thankyou very much

Hi Hui I am so sorry if I havent been very clear. can i email you tommorow as this is quite complicated and i need to step it all out for you properly. happy to pay you for this .

Hi Hui sorry i dont have much (any) experience with data tables. have been sitting here for an hour or so trying to work out whats going on. how can it generate the mix of scenarios to maximise the amount of income?

Hi there Hui hope you had a lovely New year. I hope i have done the right thing here, I have added a total Cost column in. I was thinking i should probably break these columns out as the total costs of these 'pages' are primarily based on labour hours (of which there is a finite amount...

ok got you Hui, thankyou. i will be in touch tommorow if thats ok i have a family thing on tonight. thankyou so much

should i be setting up scenario levels within the levels if that makes sense to provide for the variables?

hello i am so sorry but i dont think this is right? the level can have a choice of any of the variables i dont see how this is doing that? sorry

sorry hui i dont think i am quite following what you want me to do - sorry

hi was this file meant to be different that you attached? my apologies if i have missed something

Hi Hui thankyou for getting back to me. I have not got them feeding anywhere at present. what i need to do is say for a given level of revenue eg 900k, i can have x many combinations of levels one to five with x many combinations of the variables. so for example, a level 2 has a base cost...

hello and thankyou in advance for any help you might be able to give me. i have to create scenarios for a fixed level of revenue based on 5 levels or type of expense. each of those levels has a base cost. however those 5 levels of expense type (see attached) will have one type of variable cost...

all good - might be in touch for something else if thats ok

Hi Bosco Ok i see, i will give that a go. thankyou so much for getting back to me, i will let you know how i go , :) keasha

hello i hope someone can please help. i have uploaded a sample file for you. i have data in multiple columns (see data tab) in the first tab (x schedule view) i need to be able to look up the data depending on the columns and return the $$ value. i.e the first tab should return all the...

You are just an absolute gem Hui, thankyou so much