build

1. Build a Sort Dynamically

I am trying to work out how to build a sort when I do not know at the outset how many columns I need to sort on. The first object was to see if I could pass the range and sort key dynamically. The following Macro does that getting range and column to sort by. When I try and build the entire...
2. help with iif statement in access

Hi all, I know access is not the best at formulas, but I have certain customer names were they can have the name entered slightly differently ( like Microsoft, Microsoft Inc, Microsoft UK).. Is there a iif contains formula so that if the customer name contains Microsoft then return the word...
3. Label All Fields Under a Header

Hi, I am extracting data from a Microsoft Project file into Excel and need to write a formula to grab some data. It has a header called "Build" and then another header called "System Build". I want all the rows in between those to be labelled "Build". ex. <tbody> A B C D 1 Name Start End...
4. Build string from cells with ignoring blank

I’m trying to build a text string out of some cell, but Idon’t want the blank cells to appear. In the first table I have an a-value and two x-values. Pretty easy to create the sting. 123.45 + 15.34(x1) + 12.44(x2) =B1&" +"&B2&"("&A2&") +"&B3&"("&A3&")" Data Range <tbody> A B 1 a...
5. MACRO to build a graph - y axis not shown

Hi all I managed to create a macro to build a graph which updates each time the lenght of the columns change. When I try to put the name of the horizontal axis, it work. When I try to do the same with the vertical axis it doesn't. Anyone willing to help? I am very grateful Thanks a lot valentina
6. Scoring Formula

Hi, I am looking for two different formulas which will calculate score in B & C column respectively, logic given in below table … Please help me build the formula … Formula 1. >1.25 = 0 Increase on each step 0.132% Max 10% at 2 Formula 2. <0.21% = 0 Increase on each step 0.25% Max 5% at...
7. Periodogram- looking for cyclical data.

Hi Everybody, Can anyone help me look for cyclical data. I have some rainfall data that I want to test. I am not sure if we can build any formulas from scratch or we need xlstats. Thanks for your time. FarmerScott
8. Percent of Total - How to build report

Hi, I have some task - that looks like very easy, but... I cannot find solution :( I have data like this: <tbody> Column1 Column2 A No A Yes A No B No B Yes C Yes C Yes C No </tbody> And want to get report showing the percent of Yes/Total: <tbody> Column1 Yes/Total A...
9. Min Max formula

Hi All, Looking for min Max formula which will return following answer If A1 =<.4% Result (in B1) will be 0% & if A1=>.2% Result will be 5%. Please help me build this formula. Thanks & Regards, Sanket 7738414678
10. Loop through data and build an array

I have a sheet of data, not in table form, more like a report with blocks of data that repeat themselves as you go down the page. I want to go through the data and extract some of the data and copy it to a different worksheet. I was thinking of using the Find function to locate where each...
11. Dictionaries and vba: when to use

Hello everybody. I've been studying some of the solutions found in mrexcel.com about dictionaries. Having applied them "blindly" to my issues with success, I've decided to understand better their dynamic. Suppose I've a table like this: https://imgur.com/h2sfGql How can I build a dictionaries...
12. VBA IF Cell A is not blank And Cell D is Blank Then...

Ok. Here's another one I've tried to reverse engineer all sorts of similar formulas I've seen, but I'm always falling short. Hopefully, this is easy to someone in the know. Column A contains numerical strings in general format (don't know if that's important or not). Column D contains dates. I...
13. How to do a little more than the basic =IF logical true/false statement....???

Hello, I am trying to find a way to build on the basic IF function. IF(logical_test, [value_if_true], [value_if_false]) I want to have a few options rather than just one, such as: if A1 = 1, B2 would autofill with Good if A1 = 2, B2 would autofill with Maybe if A1 = 3, B2 would autofill with Bad...

Hi, I run an identical report every day of the week and house the individual files all in the same folder. each spreadsheet is identical with the exception of the name (the date changes) Rather than open each one and manually link them Im trying to build the cell reference including the...
15. Custom ribbon tab button disappears

Thanks in advance for your assistance. I have produced a Leave Diary builder in Excel 2010 which has a custom ribbon tab. Based on the name of the workbook, I show or hide certain buttons on the custom tab. When I open the workbook it shows only the one Build button on the custom tab. If...
16. Code to Hide/ Unhide rows using VBA

Hello, I have been searching lots of forums to see if I can find a solution to my query but not been very successful. I am looking to build a VBA into my worksheet to hide rows across numerous columns that show zero values. I would also like to have the ability to unhide these rows when new...
17. Noob Macro question

I have a database I've built. In it, I have a report that displays all of the issued equipment for an individual, based on Inputting their last name. Is there a way to build a macro that would cycle through all of the names in my database and print this report for each?
18. select from range

good day, For Each rng In Range("h4:h200") Select Case rng.Value Case "Build Completed" With Range("A" & rng.Row).Resize(1, 22) .Interior.ColorIndex = 4 .Font.Bold = True the code highlighted in red is a triggered word...
19. Using an array to calculate in what year to build sport arenas

I have a data table with cities, build year, number of seats, need for seats and the current number of seats. I am trying to calculate in what year a company should build sports arenas and in what city. I have read about static arrays and I know the size of my array. However, I am not sure...
20. VBA own codes library

Hi, I just tried some kind of Add-in (VBA Code, free test version) that provides some help when writing code (I would use less than 5% of it, and the way to start a class in really great by the way). The only feature I love and would like to do on my own is the possibility to add what they...

This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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.

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

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