desired

Hello all, New to excel here and I could use a little help, I have the following code below that has a button set up to save the entire workbook at a desired location with a desired name. It works well and all however, there are two pages that are in the workbook that I don't want them to save...

Hi, I am very new to VBA, hence the question is quite basic. However, after browsing forums, i could not tackle it myself. I was doing some modifications to the below part of a SUB. It extracts information from one sheet as per the first row and should make the ''desired output''. I have the...

Good Afternoon, I am hoping the kind people of this forum can help me arrive to a solution. I have basic excel knowledge, but what I am trying to achieve is beyond the scope of my current understanding of excel formulas. I need to do what I believe is referred to as a reverse lookup (to...

hi all.. how to creating Custom Format to typing Latitude & Longitude like this : case 1 (Latitude) <tbody> data desired result 1679755 1.679755 18632547 1.8632547 </tbody> case 2 (Longitude) <tbody> data desired result 101429118 101.429118 101419375 101.419375...

Hello All, for few of the lines, by if conditions getting the desired value, for few rows it shows as Zero, but it should have been yes or no.

Hi all I am fairly experienced with excel and have a moderate degree of visual basic experience, but I am very new to excels query editor. I have a query that contains approximately 36000 records that tracks a work production system. It creates a record every couple of minutes of a production...

Would you please help me to add numbers with certain specific/description. I just wanted to add all numbers which EAST numbers and West numbers separately as the desired result shown below <tbody> Region Amount North-West 150 South-East 200 South-West 100 North-East 150...

When I use the Format Painter to copy the formatting of a cell with NO hyperlink to a cell WITH a hyperlink I lose the default (and desired) blue hyperlink font color. The link is still there, but the font color changes to the source font color. These are hyperlinks that were added by...

First off, I believe there is a previously answered post but I can't find it for the life of me. I am looking assign a short cut to a macro that places the cursor in the Name Box so I can enter the desired value. I don't want to use the dialogue box that appears when you press F3. I would like...

Hi all, Can you guys try to figure out what's wrong with my formula? Maybe VLOOKUP is not the best function in my case once the desired result will always be in column A but I really don't know what else to try. Thanks to all!

Hi, Colum A and B contain code. I need code row to column without duplication. I prefer non array formula solutions. Any much appreciated. <colgroup><col width="64"...

Essentially, I want to be able to highlight a list in a column and run the macro. The end result would be that the macro would allow me to browse for the desired folder and within each sub-folder of the desired folder, a file for each name on the list will be created. For example, I want to...

Dear ALl, I do have a small sample data set across A1:B10 as follows. I would like to conditionally sum as per the desired result across C2:C10. Could somebody help me out with the formula which can yield the same? <colgroup><col span="2"><col></colgroup><tbody> Region Identifier Desired...

After the brilliant solution to my thread https://www.mrexcel.com/forum/excel-questions/1059039-listing-all-values-within-range-values.html (which I am still working out on understanding the code), if there is more than one requirement in the sheet, is this possible?? If Value A, Value B...

I have data that was created every 100 or so milliseconds over 5 minutes (about 3k data points). I want to average all data within a length of a second into a single data point. Here is an example of the raw data vs the desired data. There isn't a consistent amount of data points for each...

Here I am again. I am having problems with a multiple if syntax. I have three columns Desired_Presentation (col J) | Award (col K) | SUSP_Date Desired presentation will be blank or will contain a date. Award has a dropdown menu with three options LOM, MSM, and FLCROSS SUSP_Date (col L) should...

Apologies for not knowing what this may be. I have the following table and am trying to figure out if excel is even capable of indexing some value. Each number on top has 2 categories. If the desired number chosen is 34, the result should be 30 and 40 for example. If 30 is chosen, the 10 and...

I want to use VLookup or another formula to get a desired data in red. I couln't get the result that I need using this formula=VLOOKUP(val1&val2,data,col_index,0) <tbody class="SCXW170678635" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none...

I am using the formula below to calculate 10,000 or any number in column A divided by 365 days and multiply by 10 and calculate the result by a number in G1 if value in column B is "YES" or calculate by a number in H1 if the value in column B is "NO". I get the desired result when I have YES...

I want to write a formula and function which includes text and date as a desired result shown below in bold Desired Result Total Expenditures as of December 31, 2017 $100,000 The expenditures are keyed in a different sheet Monthly Expenditures Column A...