urgent excel help

  1. H

    Please help with this statement

    I have to complete the following task, but I do not know what formula I have to use, can you please give me a hand? The statement is the following: How Many Spanish calls were handled by team blue during May 2020? See picture below for your reference. Thanks in advance.
  2. L

    Need assistance with a excel and solution formula tracking monthly summary

    Hi Friends Am Having an issue with work sheet I was assigned to keep the tracking of Vessel time spent base on different KPI KPI as follows Average time spent on Full Deck on Jack-up Rigs & Barges <16 Average Time Spent on Half Deck on Jack-up Rigs & Barges <10 Average time spent on...
  3. L

    VBA code to generate Auto Serial Number and Date in excel

    Hi Guys Can anyone help out with a VBA Code that will generate Automatically Serial Number Starting from Column B2 and date in column C2 once name is entered in Column D2 Need a solution for this below is the VBA code i use but still i cant get around Private Sub Worksheet_Change(ByVal...
  4. B

    VBA - How do I cut and paste a row to another worksheet when 2 cells both say Yes

    Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...
  5. L

    Code or Formula to delete rows based on multiple criteria

    Hello all! I am looking for a code or formula to delete the entire row if it meets the following conditions... I would like the entire row deleted if "Column B" is the first instance (by column A) and it correlates to an "N" in "Column C". I would also like every row that contains the same...
  6. L

    VBA - Consolidate data and Sum mulitiple ranges

    Hi is there anyone who can help. I'm working on a project and I need a VBA Code to consolidate multiple rows based on a single column entry, then adding together the other columns. At the moment the data looks like this: <colgroup><col width="170" style="width: 128pt; mso-width-source...
  7. G

    Multiple Criteria

    HI, <colgroup><col><col><col></colgroup><tbody> ID STATUS Confirmed Status 3333 Approved 4444 Approved 2222 Approved 3333 Approved 2222 Approved 3333 Approved 1111 Not Approved 4444 Approved 1111 Not Approved 3333 Approved 3333 Approved 3333...
  8. L

    Addition (Possible) ?

    Hi, I have Data Sheet of a students, in which serial number and name of each student are given together in one cell. Is it possible to add only serial number of all? <tbody> ABC School Class VI Students 1 xxxx 2 xxxx 3 xxxx 4 xxxx 5 xxxx 6 xxxx 7 xxxx 8 xxxx 9...
  9. B

    Store some TXT values into an Array - New Type of Question

    Dears, Lets suppose I have the following database: P|GEKU1A|15|KOSVO|0|7 S|BUVBA|-25594833|-49101500|CPN|CF|0|15400|18870|23460|500|260|0|0|0|0|0|0|0 S|GEKUD|-25523178|-49023769| |TF|0|0|0|0|0|260|0|0|0|0|0|0|0 S|GEKUD|-25523178|-49023769| |IF|0|0|0|0|0|260|0|0|0|0|0|0|0...
  10. B

    Excel with VBA save good but crash on close Very Urgent Please !!!!!

    i am new in excel VBA, and after finishing below code, the function of the code is running very well and i can save it but when i try to close it i have not responding error and it crash all excel and restart it, the code has been used is : Code in workbook : Private Sub Workbook_Open()...
  11. S

    VBA excel, able to load even with different file name

    HI all!, i was asked to make the files to load in the excel more robust. Meaning the excel has to be able to load two files of different name and format to produce an output. keeping in mind format as in the the way the file is named. i have tried to do some codes myself but it would not load...
  12. C

    Cell with comma seperated values and vlookup

    1st table/report has cells with single values as well as multiple values separated by comma. <tbody> Identifier AA XY,AA,YX BE RE,WX,EW,XT AB,ER, </tbody> if any of the values in the cell is there in the 2nd table I need to filter the 1st report. 2nd table/report <tbody>...
  13. S

    Excel User Form_ List Box Macro

    Hi All, I need you help with the Listbox in Userform, I have two columns in Excel Raw file, Column A has got categories and B has got the unique data. I want to have all the Data from Column B in the list box, which falls in the category (From Column A) mentioned in TextBox1. kindly assist...
  14. Y

    Need urgent help on this

    I want to have validation while saving (without using macro) Lets say i have cell A1 to A10. If i enter data in cell A1, only then it should give validation message while saving that "Cell A2 to A10 should not be empty." Generally if cell A1 is not blank then cells A2 to A10 should not be...
  15. H

    Urgent Excel Help Needed Again!

    Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...
  16. L

    Excel formula help

    Hi, I have a list of 70 clients with contract amounts and start dates on one tab. I need to make projection for 12 months in a way that for each customer no more than 15,000 monthly revenues is included in the forecast. For instance if the contract amount is 42,000 USD then I should account...
  17. S

    Excel Dashboard

    Hi Guys, I am doomed, Please help me I need your help to create an interactive Dashboard, I have a data divided is Categories and sub categories. Complete data is divided in 6 categories, Which further are divided,1) Location wise, Further divided as 2) Manager wise and so on it end at...
  18. S

    Excel Formula to VBA

    Hi, Need your help to convert the below formula into a Button VBA, If I use this formula directly on the sheet it is getting stuck into a Circular Referance, Circular referance is because, Q7 is getting calculated from the Range selected, but I want the entries to happen in the Range as per...
  19. S

    Sumif Inception!

    Hi Everyone, I maintain a contracts database and need to automate the total qty column. Having a really tough time getting it to automatically show those numbers. Summary: This data represents one contract (internally it is contract #18, externally, it is contract #21). It is broken down into...
  20. T

    Problem with blank cell in finding top n values

    I want to find the sum of top 3 values from several datas..But if my datasheet is not complete(that means i have less than two datas) and I want to get sum of the two datas..How can I do that?(if I put 0 on the blank cells,it works.But I dont want to put 0,I need to solve it by having the blank...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top