require

  1. B

    Practice Schedule Help

    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...
  2. R

    Require formula

    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
  3. K

    Require changed of formulas as per new layout

    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>...
  4. R

    Identifying multiple values from two reoccurring conditions in a string

    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...
  5. R

    Identifying specific text from two conditions from a line of text

    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...
  6. E

    Require if formula for Met and not met

    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...
  7. H

    How to get require worksheet tab data from excel workbook

    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...
  8. D

    Formula/macro help with Dates?

    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...
  9. B

    Delete cell contents based on another cell value

    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...
  10. S

    Data required to be compiled and added up, maybe INDEX?

    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...
  11. M

    VBA Index Match & Paste???

    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...
  12. M

    Require VBA to do CF with 2 colours in the alternate rows

    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...
  13. S

    Blended average % formula Excel 2010

    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.
  14. D

    Macro to copy range from mutilple spreadsheet and paste into central file

    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...
  15. H

    Formatting requirements/restrictions for data entered into cells (formatting masks)

    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...
  16. A

    Correction require

    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
  17. A

    Macro to split, validate, concatenate and transpose

    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...
  18. R

    Require formula

    <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
  19. T

    Auto Population of a summary list

    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...
  20. K

    Require change to limit exact sum output combinations

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top