Hi everyone, please help me I want to make an auto list, data is on A1 to B7, The auto list will show the name of person that have "Y" in "Y or N" column I attached my excel file, please help Capture.JPG Attached Files Book1.xlsx‎ (8.9 KB) Download ..read more

I am manually inputting conditional formatting for 5, 10, 15, 20 etc up to a large number 5 15 25 35 45 etc are yellow for example and 10 20 30 40 50 are green Is there a formula I can use instead of the manual inputs please? Attached Images 2024-06-02_22-19-26.jpg‎ (15.1 KB) Download ..read more

Hi, Sample data : number overlap interval.xlsb -Real data 100k+ row -Decimal points number Step: 1) Start "=IF(MAX(D$2:D3)<=MIN(C$2:C3),1,"")" at row 3 to find out if "Row 3 Interval (C3,D3)" overlaps "Row 2 Interval(C$2,D$2) aka. Starting Interval(Absolute Reference,$)" 2) If yes, continue to "Row 4 Interval (C4,D4)" so the formula become "=IF(MAX(D$2:D4)<=MIN(C$2:C4),1,"")" 3) It happen at row 9, formula return "", means that Row 9 Interval do not overlaps all above intervals. Return Maximum number of overlappping intervals which is 6 in F2 (same row as Starting Interval) 4) Star ..read more

Using Excel 2010 Hello, In the example attached workbook I have 2 worksheets with count digit separately results from data Column C:J in to as below columns. 1st In to column L:S and 2nd in to column U:AB Regards, Moti Attached Files Count Digits Separately.xlsm‎ (32.9 KB) Download ..read more

Hi There! I need help, i have a worksheet name SPS which has Data i just need to use it for the cell reference. so with my formula if TextBox2 matches the list of value in Range in column A, i wanted the answer to show in Textbox1 the same row of the answer in Column C Its like, if TextBox 2 = A then show in Textbox1 = E ex. Column A | ColumnB | Column C A................1................E B................2................F C................3................G D................4................H Private Sub TextBox2_Change() Dim cell As Range Dim matchFound As Boolean matchFound = False ..read more

Can anyone help me my problem, i have 1 sheet that have multiple table of data and i wish to combine all the table data to 1 tab Please check attachment or screenshot a[table="width: 500"] ABC.xlsxScreenshot_22.png ..read more

Dear Experts ! I have an excel sales data file. Sheet 1 and Sheet 2 have sales data. I need a VBA code to highlight column "A", "B" and "C" of Sheet 1 by matching it with column "A", "B" and "C" of Sheet 2. Note: Change the date format of column "A" of Sheet 2 to the date format of column "A" of Sheet 1. Change the rounding off amount of column "C" of Sheet 2 to the same amount of column "C" of Sheet 1. For example I have highlighted some cells of Sheet 1 and Sheet 2. Rounding off decimal of above 0.5 to more 1 and below 0.5 to less 1. Data will be more in some cases. Attached Files SaleDat ..read more

Friends, I have this data with a huge list of ID's that needs the sum of Absent, Rest, and Hours/Minutes in accordance with their ID's, days, and dates. Please see attached for a clear picture. And of course, I am always here to assist further. :) Attached Files Timesheet Test for Applicant.xlsx‎ (554.9 KB) Download ..read more

Hi All, I just joined today to help me on my journey with Excel I have developed too many bad habits using self-thought excel lol ..read more

Used to use Excel a lot for work but not for over 10 years and I forgotten so much ..read more