i.e

how do i write the file name and path of my active workbook into a text file without putting it inside quotes i.e c:\temp\col.xls instead of "c:\temp\col.xls"

I have headings in row1 in sheet1 I would lie a macro to delete duplicate headings i.e only retain one unique header For eg if "branch" appears in A1 and D1 , then only delete the second duplicate i.e Col D, eg Surname is in B1 and E1, the only delete col E etc your assistance is most...

I have the following example where I found the correct SUMPRODUCT formula but I would like to reverse the order i.e.: In column A I have different names, each of these names has a corresponding value in column B see example below: The following formula can look up any name entered in C1 (i.e X)...

Is there a way to multiply every cell from Column D19 through D50 by their corresponding numbers in column G19 through G50 and adding the totals? i.e. =(D19*G19)+(D20*G20)+(D21*G21)+(D22*G22)+(D23*G23)+(D24*G24)+(D25*G25)+(D26*G26)...etc.? I'm doing it long-hand but thought there may be a way...

Hello everyone - getting confused on some nested IF statements. Any help on writing the following formula would be awesome. If a number is between 0 and 6, return the number (i.e. could be 1,2,3,4,5,6) If a number is greater than 6, then return the number 12. Thanks in advance

<tbody> Reference Desired Output Comments 250.75378 75378 Standard reference - without expected suffix i.e. ".000" 250. 75378 75378 Includes erroneous space 250 .75378 75378 Includes erroneous space 250.75378.000 75378 Standard reference (majority of cases) Text Error Text entry should...

Hi, I need to start page numbering from say 41 and so on, which need to be displayed at the bottom of each sheet i.e at the footer. please guide me how to do this. Regards

Does anyone know how to write coding such that excel will recognize the first time a particular file is opened on a computer? Situation- I have a fairly self-automated workbook/program I’ve written that does a lot on its own with menus and calculations and all- all written in vba- but I’d like...

Hello! How can I find the right column by its header and use this to other formulas? I am thinking to use index match to find the right header by INDEX/MATCH. But how to I convert the above result into the column code i.e. A:A? Thanks!

Hey all, FormR kindly helped with combining two formulas together: =IF(AND(INDEX(T:T,MATCH(E5,AF:$AF,0))=G5,INDEX(BJ:BJ,MATCH(E5,AF:$AF,0))=H5),"Yes","No") This formula is replicated in Rows until 1500 i.e...

=SUMIFS(INDIRECT("'"&$C$3&"'!h2:h365"),INDIRECT("'"&$C$3&"'!c2:c365",G3),INDIRECT("'"&$C$3&"'!d2:d365",A13)) This formula returns a value of '0', instead of 40 When I remove the indirect function, i.e =SUMIFS('2019'!H2:H365,'2019'!C2:C365,"="&G3,'2019'!D2:D365,"="&A11) I get the value 40...

Hi, I have an excel sheet which having 60 rows (aprrox. which will change every time) and 10 column of data In Column 11 I have stored Location (i.e. "Class A", "Class B", "Class C" etc) For example : Suppose Column 11 having 4 Categories then I want to send 4 emails, after...

I'm trying to write a formula to work out future potential monthly revenue based on contract start dates and their associated payment terms and value... hopefully someone can assist The input cells would be: Column V from cell V12 is the contract monthly value Column W from cell W12 is the...

Good morning, I am trying to figure out a shorter formula for figuring out what a 2% increase a year would be for the first 4 years and then a 1.5% increase for the final year. I have a value in A1 i.e. 73688 in C1 I have a value from 1 to 5 telling me what the salary increase would be for that...

I have some code, trying to format several columns as dates, what is wrong with it as it won't work? Set sht = Worksheets("Home") With sht Set tbl = .ListObjects("tblCosting") For Each tblrow In tbl.ListRows Combo = Format(tblrow.Range.Cells(1, 1)...

Using the bloomberg function for my work I am extracting numerous dates of data releases. These come in a strictly number format, as well as being in a funny order. I.E. 20100214 is 14/02/2010 20110909 is 09/09/2011 Is there a formula to amend the numbers on the left in the example to a proper...

it is my understanding that using application. Wait will only work for durations of 1 second or more I need a way of waiting either 3 milliseconds or more up to about 50 milliseconds for one function I need to perform and up to as much as 500 millisecons (i.e. half a second) for another...

I have a column that is in text format with entries like 00:01:22, 00:00:38, 00:10:55, 00:00:09, etc. These are times as in hours:minutes:seconds. I need to put a filter on these and filter anything that is greater than 15 seconds, i.e. ' > 00:00:15 ' I tried the recorder, but couldn't make it...

I have a userform label that will display price & percentage ...i.e. -$408.66 (-14.29%). Can someone assist in parsing out only the percentage (i.e. -14.29%) from the string so I can input it into a cell. Thank you kindly

Hi all, Whenever I record a macro to code a series (i.e. 10-30 steps) of simple steps (e.g. add/delete columns, new column headers, insert formulas and copy down to bottom), it often includes many instances of the formulas going to the very bottom of the data set. Super basic. But each time I...