require

Hello all, I need some help I have 10 teams that need to be scheduled for practices for a season. I have a spreadsheet of he time slots that are already predetermined. Is there way to distribute the teams across the time slots to reach their required practice counts? For example, tier teams...

Hello, I have data as mentioned below in each row. ,,,,,,,,,,,,,,,,AM,,,,,,,,,,,FE,,,,,,,BA ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,DD,,,,,, HQ,,,,,,,BB,,,,,,,,,,,,,,,,,,,,,,,DF The output that I require is as mentioned below. AM,FE,BA DD HQ,BB,DF Regards, Vikas

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Columns C:P, I got data, in the column Q have got a index formula, and in the columns S, T & U have count of 1's, X's and 2's as shown in the example sheet1 below... </SPAN></SPAN> Current Formulas</SPAN></SPAN>...

SOS, hoping someone can provide assistance to this challenge I have failed to overcome. I require to identify specific text nestled between two text values. From the example below I require to identify text values between text range '_taxonomy_' and text range ' " ', both highlighted in bold...

Would appreciate if someone may be able to assist me with my Excel problem. I have been given an exhausting row of raw data (250,000+) from which I need to try and unravel key indicators. As such I require to extract specific text from two conditions in a string. An example is below...

Hi Team, I have below data and require formula in column J,L,M&N. If the column I is <= column C then it should say met & if its greater then not met if the date is in future then it should say Within SLA. If column G is pending and the column C date is in future then it should say within SLA...

Hi Team, I have data in multiple tabs in one workbook like 40-50 tabs and i need only 8 worksheet tab data which is require for my job and my data is available in different tabs like one lies on 2nd tab and another lies on 12 tab...goes on.... Is there any short cut in macros/formula where i...

Good afternoon guys/girls! I am am new to this board and pretty much to excel so I reach out to all you experts for some very much needed help as I need this for my job role. I am recording training for staff at work and require a traffic light system for training dates, I require the...

Hello All, Im pulling my hair out just slightly trying to find some code that removes data from cells G14 & H14 based on text criteria in cell P14. I have managed to figure out some code that works for 1 row only but require this to be a running theme all the way down the sheet. Any help...

Hi there! Sorry I'm not very good at Excel and have been struggling on this for a while - I've tried so many methods and tried hard to search for an answer.. Basically I'm creating a document to help me to do my job better and I am very limited to what I can do. The report I require the data...

Hi All, I've currently got 2 worksheets in a single workbook which interact with each other. Worksheet1 pulls data from worksheet2 by using an index match, but the problem I have with this is when the data is changed in worksheet 2 this then knocks on to worksheet1. I have the excel formulas...

Hello,</SPAN></SPAN> D7:Q23 for conditional format I am using the formula "=IF(D8="",0,IF(D8=0,1,0))" with one condition background red and font white I got 8000+ rows it works fine. </SPAN></SPAN> Problem occurs when I tried to do 2 different colours for the alternate rows red & blue as shown...

Hi Everyone, Have a table of percentages from ranges C3:R3 C4:R4 C5:R5 that I require to be filled with the average percentage of another 3 ranges C7:R7 C8:R8 C9:R9. Thee 3 ranges all total 100% and I require fist set of ranges to equal the same. Many thanks in advance.

Hi i require a macro to copy a range from multiple workbooks that are saved in the same directory. The range will also be consistent V198:AG198 and the sheet name will also be the same called Budget. I then require for this range to be pasted into a central file in a list format starting in...

Hello, I would like to restrict/require certain data in cells entered into to different columns as follows: In column B the format needs to look like the following example: N1234 with the first character being an alpha value and the next four need to be numeric values In column C the format...

Dear All, Can i make a condition for range of cells in and function, Correction require in below function =IF(AND(B6:B525>=15000,B6:B525<=16000),"SERVICING","Change Oil after every 2500KM") Rgds, ak

Hi, Another scenario where I am completely stumped and not sure how to solve this. The scenario is Column A - has a list of values (one value in one cell) Column B - Multiple values separated by , or - or even single value Column C - All possible values that can be present in Column B. One...

<tbody> ID CODE OUTPUT 001 AM AM,AS,PA 001 AS 001 PA 002 ZE ZE 003 RO RO,IH 003 IH </tbody> I require formula for the above data, I have typed the output that I require, I require formula the output column Thanks, Ron

Hi I currently have a workbook that contains several sheets which has data relating to materials I require. I have one sheet that collects all of this data and will display a summary of the materials I require but currently I have it listing all of the materials for anything, even the ones I...

Using Excel2000 Hi, Till now I was using "pgc01 code" which is amazing, I found code under this link https://www.mrexcel.com/forum/excel-questions/277924-combination-help-5.html#post1424848 I require modifications code only output Permutation Repetition with a desire sums For...