requirement

  1. trishcollins

    vlookup on table column with cells containing multiple entries separated by commas

    I have a table that has a list of requirements from various documents. The table is called "Combined_Req". Each requirement is assigned a unique identifier "ID", that is in the form of "CR-1", "CR-2", etc." I have another table called "Req_by_Category" where I have consolidated like...
  2. J

    Call Center Occupancy

    Hello, I know that calls and AHT are needed to compute for the occupancy. But just wondering if occupancy can also be computed with just staffing requirement and net schedule staffed? Thanks, Jangjang;)
  3. D

    Convert ddmmyy to Customise Qtr Yr

    Hi ppl, Previously I made enquires abt converting DDMMYY to Qtr YY. Example 15012019 = Qtr1 19 But now due to some requirement in company, my Qtr1 can only starts on April 2019 Meaning from April, May, June 19 = Qtr1 19 July,Aug, Sept 19 = Qtr 2 19...
  4. N

    Update query is not working - stumped

    I have a table called Score which has records of individuals scores for a certain requirement presented by a vendor. The list of requirements is in another Table called Requirements. In the Score table we have entered a Requirement ID that corresponds to the requirement in the Requirements...
  5. P

    Excel Issue

    In a Cell the value stored is 00.00 n the number_format is text. But when i try to replace " . " with space it results in single 0. My requirement is that I should get this 0000 when I replace dot with space Plz help
  6. R

    VBA to filterout #N/A If not

    Hi all, I have the below macro wherein it will filter the value apart from #N/A and delete the entire row but i need to release the filter if the below doesn't meets the requirement. Please assist:):) Worksheets("code").Activate Range("$A$1:$BE$10").AutoFilter Field:=28, Criteria1:="<>#N/A"...
  7. D

    Using COUNTA horizontally

    I need a formula that will count the number of times the value "N" appears in cell B10 and E10....if "N" does not appear in either cell, the recipient cell (cell G10) is to remain blank <colgroup><col width="6" style="width: 5pt; mso-width-source: userset; mso-width-alt: 219;"> <col...
  8. B

    Speedometer/Gauge Help

    Hi Excel Gurus, Once again thanks to this platform that I've been learning alot with my VBA macro skills, helping me a lot to shorten my spending my time on one task. I need the suggestion of one speedometer/gauge chart which I am creating I want to add labels to it for example , 0, 10, 20...
  9. K

    VBA find matching ID then compare other values in row

    To hiker95 I went through your earlier post - https://www.mrexcel.com/forum/excel-questions/855686-vba-find-matching-id-then-compare-other-values-row.html It was very helpful.. but it works only on 6th column. My requirement is that it works in all the columns that my excel sheet has...
  10. J

    VBA to loop through sub folders and place Word template in each folder

    Hi Guys, I have been looking online but cant find anything matching my requirement and wanted to ask the question to see if it is possible. The requirement I have is I have a folder with 100's of individual sub folders, I need to place a blank word template that I have saved on the drive into...
  11. B

    Pulse fllg & count label

    Hi peoples; – I have a mental block every time I endeavour to process conditional counters where "next" count may be preceded by undefined row strings. I have stated (as precisely as I'm able) the requirement below and posted an example with manual part- fill via dropbox link. Please could...
  12. M

    Access 2013 Query Help

    I need a query to find all records that has "does not meet the requirement:" in the Fault_Message Field...See Table below...Thanks <colgroup><col><col><col><col></colgroup><tbody> SITE_ID ACCOUNT Bill Day FAULT_MESSAGE 2 14779802 1 ICB0350:CBM3700:Service EE200 does not meet the requirement...
  13. P

    Complex weighted distribution - multiple input sheets

    Hi everyone <o:p></o:p> <o:p></o:p> Would appreciate some help with a formula which tracks the percentage of time each employee utilises particular ‘Requirements’ – this information is determined by the Job each employee is assigned to. I have completed an initial version of this (with an ugly...
  14. M

    Searchable Drop down list - Data Validation - For entire coloumn**

    I have varied requirement Requirement 1: I have an excel with column A and Column right now with normal Data Validation drop down list Ex: Column A contains drop down variables like India, China, Japan, US, Indonesia Column B contains drop down variables like places of respective...
  15. C

    Incrementing Requirement ID

    I need to increment sr[01], sr[02], etc.. in an excel column how would i do that? Thanks!
  16. MartinS

    Specific Validation (RegEx?) without VBA?

    I am trying to find out if I can achieve something in Excel to apply some validation, but without using VBA if possible? I have a requirement to validate a column to allow either NNNNNNN.NN or NNNNNNN.NN.NN (N always being numeric). The data will then be imported into SQL by another process, but...
  17. M

    Multiplying a Cell base on Adjacent Column

    Hello Folks,I have a very complex requirement. I need a macro to multiply based on some conditions. I have a two column one is filled with "Y" and "N" letters another one is filled with numbers. My requirement is to identify all the "Y" succeeded by "N" and multiply the value of adjacent cell to...
  18. A

    Pasting Data Upwards

    Good afternoon, I have some data in cells A1:B10. I want to paste directly into another excel sheet, but fill the data upwards instead of downwards. For example, I want to paste directly into D80, so B10 = D80 and A10 = C80. Is there some settings I need to enable or some formula to...
  19. T

    Return the last used colum id

    I'm attempting to identify the last populated COLUMN. The following snippet of code returns the number 37, how do I translate 37 into column "AK"? LC = Cells(9, Columns.Count).End(xlToLeft).Column Or maybe you have a better way of achieving my requirement. Thanks
  20. R

    VlookupMatchMatch/IndexMatchMatch help

    Hi I'm trying to look from one table to another, to see if a match is found (easy enough with vlookup) but i want to match on Code first, then on a specific requirement and that requirement could be found in any one of 11 columns in one row and i'm struggling to do this so any help much...

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