1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

# Recent Activity

Activity stream for all registered members at Chandoo.org Excel Forums - Become Awesome in Excel.

1. ### Eloise T attached a file to the thread What is An Array formula.

ANY formula that has an array in it REQUIRES using Control+Shift+Enter or it won't work correctly. Excel automatically inserts the formula...

Jun 28, 2017 at 1:47 AM
2. ### Hui attached a file to the thread What is An Array formula.

A Normal formula works as entered eg: =sum(A1:A10) Enter =55 will return the sum of the range A1:A10 [ATTACH] An array formula processes...

Jun 28, 2017 at 1:21 AM
3. ### Eloise T attached a file to the thread CHANGE CASE function.

Which version? The combined (see immediately below): .Value = .Parent.Evaluate(Replace("IF(#>"""",TRIM(CLEAN(#)),"""")", "#", .Address))...

Jun 28, 2017 at 1:02 AM
4. ### Bomino liked SirJB7's post in the thread Macro to delete rows when subtotal is equal to a certain value.

Hi, Bomino! Just replace this sentence: If lMin = 0 Then lMin = klMin by this one: If lMin = 0 Then Exit Sub Regards!

Jun 28, 2017 at 12:26 AM
5. ### Nebu attached a file to the thread Finding a string from a cell and resulting the matched string.

Hi: May be something like this? =LOOKUP(2^15,SEARCH(\$D\$1,A1),\$D\$1) Thanks

Jun 27, 2017 at 11:59 PM
6. ### SirJB7 replied to the thread Code for pasting data in last row.

Hi, Veeru106! Missing " _" after "xlPasteValues," Regards!

Jun 27, 2017 at 11:48 PM
7. ### r2c2 attached a file to the thread Distribute tasks of employees equally among themselves.

@Jagbuzz Welcome to Chandoo.org forums and thanks for posting your question. Interesting problem. However, I will say that it is not...

Jun 27, 2017 at 11:29 PM
8. ### SirJB7 replied to the thread Code for outlook attachment.

Hi, Veeru106! Try replacing this: strFolderpath = CreateObject("WScript.Shell").SpecialFolders(16) by: strFolderpath =...

Jun 27, 2017 at 11:28 PM
9. ### SirJB7 replied to the thread Macro to delete rows when subtotal is equal to a certain value.

Hi, Bomino! Just replace this sentence: If lMin = 0 Then lMin = klMin by this one: If lMin = 0 Then Exit Sub Regards!

Jun 27, 2017 at 11:25 PM
10. ### Logit replied to the thread How to skip over block of code once an errors occurs?.

Your code should work with a slight change. Here is the version with the GoTo commands: Option Explicit Sub test() Dim Sheets As Sheet1...

Jun 27, 2017 at 10:53 PM
11. ### r2c2 replied to the thread Finding a string from a cell and resulting the matched string.

@navi1620 Here is one formula that returns the first matching text by looking up A1 against a range of cells in E1:E3. This will return...

Jun 27, 2017 at 10:43 PM
12. navi1620 posted a new thread.

### Finding a string from a cell and resulting the matched string

Hello All, Need help with below situation I've data available in a cell (say A1) as below: abc|bcd|xyz|prq|uvw Iam looking for a logic...

#### Forum: Ask an Excel Question

Jun 27, 2017 at 10:07 PM
13. AthmanArumugam posted a new thread.

### What is An Array formula

I am still not completely clear as to what an array formula is in excel. What is the benefit of clicking CTRL+ENTER and getting the {}...

#### Forum: Ask an Excel Question

Jun 27, 2017 at 10:04 PM
14. ### Im_Offset replied to the thread Can you format cells to show height in feet and inches?.

That is awesome! Exactly what I was looking for. Thank you!

Jun 27, 2017 at 9:15 PM
15. ### Im_Offset liked Nikunj Rastogi's post in the thread Can you format cells to show height in feet and inches?.

Hi it is very easy to change cell format according to your requirement and also you can easily sort this data. Go through with my...

Jun 27, 2017 at 9:14 PM