coloumn

Hi, Thanks in advance, Need help to remove the value in coloumn in following sheet if only "0" coming Coloumn A 8 6 0 0 2 7 0 0 0 Formula or VBA will delete all the "0" after 7 I have also coloumn B, C, D and E

Hi, Thanks in advance, i have three columns and want to compare them, conditions are 1- If Coloumn 1 & Coloumn 2 are equal - Delete entire row 2- If Coloumn 2 & Coloumn 3 are equal - Delete entire row 3- If Coloumn 1 & Coloumn 3 are equal - Delete entire row please provide any VBA or code...

Dear All, Could you please suggest me how to define the following requirement in Excel. In Coloumn A I have some value, in coloumn B Start Date, Column C Finish date. In column D I need to get column A value if column C has date format otherwise column D should display 0. Thank you in Advance

Hi.. I want to clear cells contents from column D to N When the cell in column A is empty for each row, or when I delete the cell from A coloumn

I have this formula which is in my time sheet B4 is the date that it must add all my work for the day but i now have three other columns that i would like to add which is in Coloumn I (Sick); J (Annual; K (PPH). How do i add them to this below formula...

Hello, I'm struggling with a workbook that holds quite a lot of data. I would like to count unique values in column AX, whereas i also would like to be able to count unique values in case a sorting filter is used. I made a matrix-formula for the general unique values count, that works...

I'm trying to copy the contents of a sheet into a new .xlsx document. I can not keep source coloumn widht and row height.:warning: For i = 1 To wksht.Range("A" & wksht.Rows.Count).End(xlUp).Row Set wb = Application.Workbooks.Add dataRange.Copy wb.Sheets(1).Range("A1"...

I am trying to get a VBA code to work. I have a sheet with a coloumn (A) with a header called: "Documents - close to deadline" I then have Coloumn C is "weeks until deadline" Coloumn D is "Document name". I can have any number of documents (not predetermined) depending on the project or...

I have a workbook with over 100 worksheet. In each sheet I have a table, but each table is a slightly different size. I want to set cell A1 to be the average of every cell in the table. I suspect this will require a macro to ensure we only get as many cells as necessary. The first row and...

Dear all excel super users I have a problem I would like you to help me with  I have the following VBA code, this imports data from a separate file name “query_export_results.csv”, and sort, format etc. In my import file (“query_export_results.csv”) I have added a new coloumn (L) which I would...

For example, pls see the table at the bottom of this post. I would like to be able to input the start country into cell A1 and have excel return all values in the column above 0% and the corresponding headers. I've tried with index but can only get the percentages, and not the corresponding...