microsoft excel

Below is the table for late attendance deductions: This is monthly attendance data and for example: How do you calculate late attendance deductions with the above data based on minutes? In the example above, an employee with the name Nara Susilowati has a salary of 10,000/month. This month...

can u help me please :) how to Lookup Duplikat Values in excel using Formula Please Help Me

I currently have my data in different columns after using a Text To Columns feature. Now what I want to do is to put them all into one column. Can you please advise what formula to use or is there a custom script please? I have got Office 365 for Mac. Thank you . I am computer literate but not...

{=SUM(INDIRECT("'sheet1'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$2,INDIRECT("'sheet1'!A1:"&SUBSTITUTE(ADDRESS(1,O1+16,4),"1","")&ROWS($M$1:$M$1)),0),4),"1","")&XMATCH($B3,INDIRECT("'sheet1'!$m$1:$m"&M1),0)):INDIRECT("'sheet1'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$2,INDIRECT("'sheet1'!A1:"&SUBSTITUTE(ADDRESS(1...

Dear All, I was trying to delete the duplicate values which comes from XLOOKUP formula but is same for several dates. For example, in attached file, In column C, HCFT comes from the Xlookup on Column B. However, the value in Column C is repetitive for the same date. I am looking for a VBA to...

It is highlighting the "*** portion of the "Assorted" after the then

I have this workbook that has columns A through E with information. For column A, I was looking for a VBA that will compare the current data in the cell (starts at A2) until the end of data, to see if it matches with data in ("Sheet2") range would be G2 until the end of data. This will go...

Excel vba will not recognise that AutoFilter is enabled. However, it works on the initial sheet which the code is run from. Using code: If ActiveSheet.AutoFilterMode Then Option 1 Else Option 2 End If I have tried to use vba prior to the above code, to remove and re-add the...

How do I create a 12-month table with several variables in Excel? Say I start with 5 possible X values and have two growth factors, each with 5 proposed values I want to test (Z1-5+Y1-5) through the end of the 12th month and see the product of each combination (125) like a large tree diagram would.

I am trying to find a formula to find the number of concurrent calls at one time. My columns contain phone provider, outbound number, inbound number, start date and time (one cell), duration of call, and end date and time (one cell) from A to H in the order they are listed. In this stage of the...

I am hoping to find assistance with a formula that will help me identify which requisitions have been fully or partially awarded. Each requisition may have multiple lines and none, some, or all of the lines might be awarded. In the example below Requisition 111111 has three line items, but...

Hello, I have a thousands of columns of quotations in MS-Excel. I would like to punctuate them. Is there a formula I can use to do it? For Example: I would like to change: abc to "abc". Thanks in advance.

Hi, Wondering if someone can help with outlining the key benefits, restrictions and differences between Microsoft Access, Power Pivots in Excel and Get and Transfer data function? I have two separate documents of data: one product sales by line by store and one with stock holding by line by...

I am new to Excel formulas. I have 3 list in 3 different columns in Sheet2 as below. <colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody> <tbody> List1 List2 List3 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 6 6 7 7 8...

Hello, I would like to know if there is a way to automatically update the content of a cell based on the value of a cell in another sheet ? That original cell's value is based on a drop down menu. Could someone exlpain to me how to make it work ? Thank you very much for your help

Hi there, In my worksheet prices update from trading terminal every minute for 27 stocks. sheet 1 named "bank" has 27 stocks where from F3 to F29 live prices of 27 different stocks are streaming and changing. Now what I need... 1. After 3 minutes of market opening time 9.15 A.M, prices get...

Hi, Thank you for reading this thread. I need your help creating a macro. I have two excel spreadsheets. .i.e 1) Pivot table 2) Reports. (Report file is shared). The data in the both spreadsheets is as under. Column A) Client names Column B) Outstanding balance. I want to create a macro...

Hi there. This seems like it should be really easy, but I've been wracking my brain over it for the last few hours. I have a spreadsheet I'm using that has a number of locations in one row, and I want to retrieve the data from the appropriate column based on the location name. For the most...

I've got what's probably a simple question concerning Microsoft Excel 2013 that I just can't figure out the answer to. I have cell A1 that contains a name in the form of two words, such as "Jane Doe". In two separate columns, I have separate lists of first and last names. Here's what it looks...

Hello, I have the below code that will copy a table in Excel and then paste it into Word. However I cannot get it to autofitcontents to the page: Sheet2.Range("F6:L" & (46 - Application.WorksheetFunction.CountBlank(Sheet2.Range("F6:F51"))) + 5).Copy...