requirement

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

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;)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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