Search results

hi @pecoflyer , thanks! but this is what the company is using for now and I have no rights to request for an upgrade. what i need is just a simple formula to obtain what is needed. :):)

hi @pecoflyer, i am using a 97-2003 version of excel. HC means Head Count

Hi Team, I have a data consisting of HC being monitored on a weekly basis; seeking your assistance so that I could get the current month's running week's ending HC. example for September: Starting HC is the ending HC from August and ending HC is the 4th week of September WB0924...

Hi Team, i got this text file from our IT Group wherein i need to extract the email address per row. i tried this formula but i can't seems to figure out how to obtain the correct answer. =IFERROR(TRIM(LEFT(SUBSTITUTE(MID(A1,SEARCH("tdcx.com",A1),SEARCH("...

Hi Team, need help on these please; i need a formula wherein it would reflect the unaccounted/not yet rendered OT hrs within a day's shift to reflect in column I everytime i changed the time stamp in cell H2 (10:00 pm) conditions: - in below screenshot, i still have 2 remaining hrs in row 14...

Hi Team, I need help with this one please. I am having difficulty creating formulas for the above 8 hrs condition for i am getting the same result as that of 4 hrs to 8 hrs condition. kindly take note that every entry should reflect only the highest Tier attained and will automatically...

Hi pecoflyer, this is good, although I have made some revision since when I dragged it downwards, all rows starting from previous hours would show "handled" below is the revision i have made: =IF(AND(COUNTIF($B$2:$B$1541,$B2)>1,COUNTBLANK($C2:$E2)<>3),"rolled over"...

Hi Team, may i seek an assistance with regards to the attached file; I need to tag each row as "rolled over", "new case" or "handled" accordingly. these were 2 sets of data; comparison of data produced every two hours the latest hour contains columns B to E while the previous hour contains only...

Hi, need help once again! I have this one file were I am extracting certain data; the issue i am facing here is that the raw data is most often changing, see difference from raw data and raw data (2) sheets of the attach file. Raw Data shows data needed on columns B, N, Z, AL, AX, BJ & BV Raw...

Hi bosco_yip, This was a great alternative. Thanks as always :)

Hi GraH - Guido, This works well, i just need to adjust the last portion of the formula from "+2" to "+1". :)

Hi Team, need help please! I need to extract the email address only from a certain strings of words Ronaldo Alvarez <ronaldo.alvarez@xxx.com> used: =LEFT(B1,FIND(" <",B1)) to extract the name only then used: =RIGHT(B1,LEN(B1)-LEN(LEFT(B1,FIND(" <",B1)))) to supposedly extract email...

It's actually a tableau data being extracted and exported to excel, there's no way to extract it only by a particular column. In addition, since the tableau is relatively new to the client and they do often times updating it, columns were actually interchanging after the updates. the names now...

Hi Hi Vletm, Thanks for the provided formula, it works well. With regards to your question about the several columns, unfortunately, that was the raw data generated and extracted from our client's tools. We really don't need each of it but just the columns on the formula. Your suggestion to...

Hi Team, Need help please! I need to add up a column using another column with date and time combination, but I need to use date only as my criteria. I was able to add it up, however, I still need to do a Text-to-Column operations so that the particular column should contain only the date...

Hi Team, I have this dilemma on my worksheet wherein I need to identify the equivalent charges for a transfer amount based on the table on the left. here are some of the requirements: formulas should reflect on D column D2 & D3 formula to reflect the actual charges based on transfer amount D4...

Hi Team, Asking for your help with regards to the attached file wherein the corresponding Time In and Time out of each employee would reflect for the provided date based on the raw data from another sheet. I tried using helper columns but i managed to do only the Time In portion. kindly...

Hi Team, please hep me figure out how to convert time to text format upon pasting to excel: - here's the scenario, we are retrieving data from a certain application that shows the actual time in minutes and seconds (mm:ss) of a particular person in a certain activity; - however, upon copying...

Hello, we may disregard other schedules as shown for we are based on the start of the week and not on any other day. thanks, Rhon

Hi Team, Kindly help me create formula to extract a certain person's daily schedules and scheduled rest days for the week based from raw data from different sheet. please find attached file thank you in advance.

Hello r2c2, I have no idea yet on how to set the sort and refresh data on pivots. may you please walk me through it. thanks on advance, Rhon

Hi Team, Is there any way where a pivot table will be sorted automatically based on a certain column when the raw data was completely changed without using a macro command? We have this 1 report file wherein we need to submit on a daily basis so our raw data will be updated on a daily basis. I...

Hi Team, Is there any way we can simplify a nested formula like this one without using any VBA? this was just a repetitive sum of data from 3 columns divided by another column, however, the trick is: this was on a daily basis, per date, and with different skills listed on the formula such as...

Hi Team, any help with regards to time computation; my formula only reads those in hours and even if i do add the formula "minute", it doesn't count those entries of 0:30 mins. for example: CORE = 26.00 when it should have been 27.00 TMT = 5.00 when it should have been 5.30 thanks in advance.

Hi Hui, Got it! thanks for the enlightenment. :) :)