mrexcel

  1. C

    MrExcel podcast 1505

    Hi, I have created a stock inventory sheet for ten product in MrExcel podcast 1505 auto next invoice.I want to reduce stock automatically when generate invoice. Just like auto postregister podcast 1808. Thanks in advance
  2. MrKowz

    MrExcel HTML Maker Update

    Forum Members, After the recent forum update, the MrExcel HTML Maker ceased to function as intended due to HTML colors being defined as hex (i.e. #DAEF5 ), which was triggering the hashtag functionality of the boards. I've updated the code to utilize RGB instead (i.e. rgb(218,231,245)) which...
  3. H

    SUM formula but with some cells that contain N/A

    Hi all, In a MASSIVE predicament and any help I can glean would be amaaaaaaazing! I am trying to do a simple SUM formula but with some cells that contain N/A and I REALLY need to find a way of the formula ignoring the N/A values / adding this as 0. I am not doing a simple '=SUM(A1:A10)' I am...
  4. H

    Help help help please please please

    Hi all :smile: In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell B1 etc). Underneath each date (which is effectively the column header) I have ten rows of numbers. I need to be able to type a date into a cell on another sheet and have a...
  5. H

    Help help help please please please

    Hi all :smile: In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell A2 etc). Underneath each date (which is effectively the column header) I have ten rows of numbers. I need to be able to type a date into a cell on another sheet and have a...
  6. M

    Modifocation time of a cell

    Dears Really i need your help as i want an equation or a code to detect the modification time of a certain cell as a static text
  7. CAT2016

    Sum every 'nth' row - NOT WORKING

    Hi I have been reading a few threads here today about adding cells together every 'nth' row and I am having some success and some failures. I have managed to add up a range of cells (every 6) in a column using this formula =SUMPRODUCT($C$10:$C$154*(MOD(ROW($C$10:$C$154),6)=1)) but it doesn't...
  8. I

    Accounts Receivable Aging help Fifo Credit Basis

    Hellow, I am preparing accounts receivable aging. Its working to extract. Records according to due days but i need formula which less the amounts according to fifo basis. I means if some amount amount i post in credit enerty it nuteralize oldest category rest other remaining same. Need help...
  9. S

    Drop down list search options

    Is there is any method to easily select data from excel drop down list? as an example if drop down box contain 100 selected options and i want to go quickly options started from letter "U" .now i have to scroll down each and every select time. my requirement is very similar to option available...
  10. I

    sumifs with greater than and equals criteria

    Hello, Please Guide me On Following. i want to sumifs on second criteria >0<30 ist criteria is text based match which is working. Regards Farhan
  11. S

    How to set dropdown input value base on another dropdown list select value

    i have 2 drop down list (form control combo box) 1st one contains A,B,C i want to set 2nd one selected list based on 1st one selected value.that means if i select A in 1st one i want to set D,E,F in 2nd one and if i Select B in 1st one and i want to set 2nd list G,H,I.how can i do this .please...
  12. S

    how to develop macro to download report from online website in excel format

    I am very new to the macros.I want to know can we develop a macro to download report from online website.based on the names which i can select form drop-down list,i want to download same reports for each name.can i do this using macros. Please help me to do this.
  13. S

    CONCATENATE function

    Hi All, There is a problem i am facing with CONCATENATE function. Here is in below table. <colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody> Harry AC DA PC KA Stu DA KA Neena PC...
  14. S

    Text formula

    Hi, Thanks for your videos. I have a question as below. I have a table containing some products. RCCO NK-3325 TRD 633 PL 1 KG NK IN RCCO NK-3325 TRD 633 PL 2 KG NK IN RCCO NK-5251 TRD 633 PL 1 KG NK IN RCCO NK-5251 TRD 633 PL 2 KG NK IN RCCO NK-6302 TRD 633 PL 1 KG NK IN Brand is NK-3325...
  15. P

    Macro for Already open IE Window

    Hi, I'm looking to create a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> macro which will be ran from...
  16. J

    IF statement & corresponding max value

    I am close on this, but can't quite get it figured out. Thanks for the help! Below is the data that I am working with. In a new cell I want to create a formula that will match the License # in column A with the correct Maintenance in column B and give me the latest date for that particular...

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
Back
Top