mrexcel mvp

Long time Reader First Time Pleader - Guy I hope none has asked this same question exactly. I have a 1400 fields in db object- i need the count of fields usage from the fields inception date. Table one: Column A is the field Name then Created date field and then countif range from table two...

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...

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...

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

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...

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.

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...

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...

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...

Hi Experts, I have the VBA code and i want to bold and underline the below text : Required Information : - Client/Information/Year : Comments : Please help me out in getting the syntax to make text as BOLD/UNDERLINE...in VBA... Sub Mail() ' ' ' ' 'Macro Purpose: To send an email through...