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. ### John Jairo V replied to the thread Calculate months as 1.1/2th of a year.

Hi, Kelly! I'm lost here. Helps a lot if you put manually the results that you want in your excel, and explain how it works. Help us to...

Jan 24, 2019 at 12:41 PM
2. ### Belleke replied to the thread Pivot table age and gender..

do You mean from these four cells The real table has more than 450 participants The group option worked. Thanks.

Jan 24, 2019 at 11:38 AM
3. ### vletm attached a file to the thread Pivot table age and gender..

Dates should come from kolomn b. ... do You mean from these four cells? [ATTACH] ... and what kind of output would You like to get? Seems...

Jan 24, 2019 at 11:27 AM
4. ### deciog liked Peter Bartholomew's post in the thread High and Lows of a sum.

It is possible to calculate a running balance in memory and then use MAX and MIN to identify the extremes. The named formula 'Balance' =...

Jan 24, 2019 at 11:21 AM
5. ### deciog replied to the thread High and Lows of a sum.

Peter, Very good solution I liked it Decio

Jan 24, 2019 at 11:21 AM
6. ### Rahul Agarwal replied to the thread How to OMIT blank lines present within data in a cell..

@Ajesh No this is not working, still there are blank lines coming in WORD document. I just want information present in a cell to be pasted...

Jan 24, 2019 at 11:16 AM
7. ### Belleke replied to the thread Pivot table age and gender..

How do you get these? <6 or (blank) 6-15 26-35 I have 15 35 42 53

Jan 24, 2019 at 11:11 AM
8. ### nagovind replied to the thread Number Formatting a cell with negative values.

Dear Bosco, This is working for me [<0]"FUEL"-0.00"˚";[>0]"FUEL"0.00"˚" https://chandoo.org/wp/custom-number-formats-colors/ Thank you

Jan 24, 2019 at 10:57 AM
9. ### Ajesh replied to the thread How to OMIT blank lines present within data in a cell..

Does this help: s = Replace(Trim(Sheet.Sheets("Weekly Update").Range(Cell_name).Value), Chr(10) & Chr(10), Chr(10))

Jan 24, 2019 at 10:57 AM
10. ### Belleke replied to the thread Pivot table age and gender..

Dates should come from kolomn b. Dan I can select a month and i get the list with the Participants of selected month. It is the first time...

Jan 24, 2019 at 10:52 AM
11. ### nagovind replied to the thread Input Box with Picture Logo.

Dear Hui, I understand, really I forget the user from. I believe I can do it. I will try if not possible I will revert Thank you

Jan 24, 2019 at 10:49 AM
12. ### Rahul Agarwal attached a file to the thread How to OMIT blank lines present within data in a cell..

Any blank line between data present in a cell is not required to get pasted in WORD.

Jan 24, 2019 at 10:45 AM
13. ### AlanSidman replied to the thread How to OMIT blank lines present within data in a cell..

Upload a sample file representative of your actual file. In this manner, we can see what your raw data actually looks like. For example,...

Jan 24, 2019 at 10:38 AM
14. ### vletm replied to the thread Pivot table age and gender..

Belleke Many things are possible ... but ... Which dates? Eg tThere are totally two birthday-dates.

Jan 24, 2019 at 10:38 AM
15. ### Derek McGill liked Marc L's post in the thread Find a letter "O" and convert the number in Negative in another Range.

Hi ! According to the attachment, an Excel way : Sub Demo1() V = ActiveSheet.UsedRange.Rows.Count Range("L2:L" & V).Value2 =...

Jan 24, 2019 at 10:35 AM