needed

Struggling to make this work for me, probable cause - complete novice. I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks. I cheated a little and did the...

Hi I am working on some financial data were i am using different method to trend some of the values in a specific column. i need to specify whatever formula used in the column to derive values to the very next column. <tbody> 2001 2002 2003 2004 2005 Derived Tag 10 23 34 43 <tbody>...

Hello all, formula needed for the following please if you can help A1 B1 D1 E1 Dog fido Dog 4 dog jess Cat 3 dog rover dog max cat...

If I need to choose (Column B) from a list of numbers (Column A). How do I consolidate the numbers in column B to look like column C> See below for example: Column A Column B Column C 3216549871 1 3216549871 7894561232 5468949745 5468949745...

Hello - I am looking for a formula only to help do this if possible? I have 2 groups of data that I want to combine into one result and not show the blank cells Both data ranges are fixed The result needed will be as long as is needed to capture all the non blank cells Need the result to list...

Hello, I have a spreadsheet with two tabs and a table in each. The first tab contains data that is added to on a regular basis, say column D is called "Complete", what i want is if a a row in the first tab has a "Y" entered in the complete column then that row is moved from the first tab to the...

Morning Everyone I am hoping to get a little help. I'm stuck on my formula. Using standard Net Promoter Score surveys I am looking to calculate how many promoters are needed to attain goal. the formula we use is the following P=Promoter N=Neutral D=Detractor (P-D)/(P+N+D) What I have so far is...

Trying to get a formula to retrieve data (The Time) from a cell on another sheet. =IFERROR(INDIRECT(LEFT("'"&D8&"-TVDB'!"&"AB7"),FIND("M","'"&D8&"-TVDB'!"&"AB7",1)),"Unknown") D8 is the sheet name with -TVDB tagged on the end ex. The Simpsons-TVDB On The Simpsons-TVDB sheet in AB7 cell is...

HI, I am needing to extract 2 bits of information from this spreadsheet below, all based around numbers in column A which are product numbers. this is for an ordering sheet. I need to know the next date that the product is needed. I need to know how much of that product is needed, which is...

need formula if cell G19 is between 19 and 99 then cell W19 get X if not then A

I am trying to write a code so that the last input is saved in each of the text boxes in the user form in the most recent submission. I want it to recall the current price on an item, so it can be compared and changed if needed. It is rare that we change prices on all items, but there is always...

Hi, I have a spreadsheet with various credit and debit amounts, what I need to do is match a number of the credits to one of the debits (exact amount needed). Is there a formula or macro that would enable me to do this. Help greatly appreciated

Hi, please look at the screen shot below: I needed a code to set the Display Object , show to All. thanks

I have a range that I would like to copy the formatting for to other pages. I have been using the Format Painter, but it seems there should be a better way. Is it possible to save the formatting of a range, and then apply it to another ranger whenever needed? Thanks!

Is it possible to get Excel to check a column for a certain result ( invoice Needed ) and if that result exists add the PO number from Column A into the next cell in a different table, or am i asking too much of excel? So in this example both 181/GB and 185/GB would need to added to the...

I have 5 names from G3 to G7, I need to have these 5 names horizontally from G3 to K3

Hi everyone, how am I going to hide all sheet tabs in my workbook.help needed please.

This may be very simple, but I can not find a way to easily do this. I can export all the data needed, but I want to be able to quickly view just the rows that are needed. For example I will use baseball stats Below: This Exported sheet includes a list Every Single baseball player however I...

Formulas needed Col AB from lines 19 to 9999 has numbers 0.01 to 750.00 I need to count cells that contain numbers from 10.00 to 19.99 also the sum of those cells

Is it possible to set the height, depending on number of rows ? Or Find what the listbox height is? I tried using the number of entries, but the height needed is not evenly multiplied. Also, you can't hide the Gridlines, can you ?