aladin akyurek

Hello Friends, I need a formula to show unique count in column F as 0 or 1 based on key present in column E. Note that column E is not sorted. Given that I have 0.5 million rows data, need any effective formula that will not impact the performance of the excel file. Thanks a lot in advance to...

Hi Formula Champions, EFGHIJKLMN122%38%20%20%2RW Total Emp AEmp A Yes/NoEmp BEmp B Yes/NoEmp CEmp C Yes/NoEmp DEmp D Yes/NoDiff - Should net to 0310022Yes0No22Yes22Yes-3441000No0No22Yes22Yes-56L3:L4,J3:J4,H3,F3:F4F3=IF(G3="No",0,$E$3*$F$1)H4H4=IF(I4="No",0,$E$3*H2)N3:N4N3=(F3+H3+J3+L3)-E3 I...

Good day Can you please help me to make a formula related as per below table, now I am manually doing the process, the logic is like this, I would like to get only the hours spent from the range of 9:00pm to 6:00am. For example: In item # 1- The workers starts to work from 6:27am until 10:09pm...

Hello all, I have shared two tables below, first one is a DATA SOURCE and second one is the DESIRED RESULT. I want the DESIRED RESULT in yellow highlighted columns in the 2nd table. I am looking for a particular formula which can read and match the product ID from DATA SOURCE and distribute...

i have below pivot where i want to extract the bottom 2 percentage from satisfied/Dissatisfied column at an custom and supervisor level. Years Supervisor Custom Satisfied/Dis-satisfied of inquiries 2019 asmani1 Aalia 100% 5 2019 asmani1 judaan 33% 6 2019 asmani1 Kompal 67% 2 2019...

I am trying to match column A & B. I am not looking for exact match. For example cell A4 & B4 here we have Korea as a common word. If found then output column which is column C should say yes else no. Country 1 Country 2 Final Output CCBSI-INTERNATIONAL HQ - INDIA INDIA Yes...

AUNZ:- In discussion with PB CN:- HK:- IN:- Deal closed ID:- JP:- KR:- MY:- No action required AUNZ:- In discussion with PB IN:- Deal closed MY:- No action required A1:AH is the data in column...

We have different countries available in column A In Column B & C from row 3 we have the raw data in cell B2 & C2 we have the final output What I am looking for is 1 - In column B from B3:B12 find unique values 2 - concatenate the unique values with the countries present in column A...

Column B & C we have the raw data in Column F we want the final output based on column E Output Country Item Lookup value: Results Monday Pipe Monday Pipe Monday HK Monday HK Monday Call Monday Call Tuesday LE Monday Tuesday Top 50 Monday Thursday IPS...

Date Holiday Business Day Friday, November 1, 2019 No 1 Monday, November 4, 2019 Yes - Tuesday, November 5, 2019 No 2 Tuesday, November 5, 2019 No 2 Tuesday, November 5, 2019 No 2 Wednesday, November 6, 2019 Yes - Thursday, November 7, 2019 No 4 Friday, November 8, 2019 No 5...

Book1ABCDEFG1Input Data2DateBDFrequencyActivity3Friday, November 1, 20191WeeklyMgmt Report4Monday, November 4, 20194WeeklyRevenue Report5Monday, November 4, 20194WeeklyTrade Report6Tuesday, November 5, 20195Bi WeeklyForecasting7Tuesday, November 5, 20195Bi WeeklyIncome Statement8Wednesday...

Based ob below 5 criteria, I want the output in Column G i.e. in Column "Final Comment" <colgroup><col style="width:120pt" span="7" width="160"> </colgroup><tbody> Qualifying EU LDD Migration date/(Allocated date) KYC Next Renewal Date Date Equivalency Required By KYC...

Book1ABCDEF1Risk RaitingCountryRenewal dateOutputRelevant countries2LowCanada;Germany;UKFriday, October 26, 2018YesUK3HighCanada;Luxembourg;UKSaturday, October 27, 2018NoUnited Kingdom4MediumAU;EMEA;NZFriday, October 19, 2018NoEMEA5LowLuxembourgFriday, October 27, 2017YesBE6MediumAusSaturday...

Hi All, My data in below format. 1) Sheet Name PCI : A4:D column contains data , which I am getting by running below code 2) Now suppose my output in range A4: D6 came after running the below macro is :- <tbody> ID_Cell PCI RRS Cell Range(km) A123 1 2 3 B123 4 5 6...

Hello everyone! I currently have a workbook that I use the index/match function along with IF statements. I have two tabs: first tab contains my clean list of data that pulls from my data export on tab 2. Below is a small snippet of the portion I am trying to find a solution. I want to pull...

I extract data and pull in to graphs. Quite often, I have 99% or 101% with the data that I am assessing. How do I tell Excel to look at my values and round those that make the most sense so that when added together equal 100%. I spend so much time looking at these partial percentages...

Good evening all. I apologize for just asking for help. I normally muddle through these tasks and figure it out. I have a short fuzed task to pull this together. I am looking to pull 2 separate lists out of one main list. Main is the complete "action tracker". List 1 is what was worked on...

Hi all! Been a while since my last post. I have multiple worksheets in a workbook. Using worksheets CIP 1.1 & 1.2 and Working Data. Column P is completion date, formatted as a date, on CIP 1.1 & 1.2 tab. Column F is completion date on Working Data tab. Formula is in F and dragged down...

Hi All, I need to create a Pivot table of a data where I have some values as %s and some values are as Numeric. I need to show data in pivot table as %s where data value as % and data as numeric where data values are numeric. I have created a new variable where I have multiplied the data...

Hi, I'm trying to use a SUMIF formula in which the criteria is in one column but it has multiple sum ranges determined by the values in a row. Below is a summary of the worksheet from which the formula is being linked. The first column (numbers 1 - 5) and top row (K.5.1.3) represent the...