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. ### NARAYANK991 liked bosco_yip's post in the thread Unique List of Names and Count Type of Project.

Formula solution way, 1] A3, array formula copied down : =IFERROR(INDIRECT("'Kaizen Log'!"&TEXT(MIN(IF((COUNTIF(A\$1:A1,'Kaizen...

Aug 18, 2017 at 3:18 PM
2. ### bosco_yip attached a file to the thread Unique List of Names and Count Type of Project.

Formula solution way, 1] A3, array formula copied down : =IFERROR(INDIRECT("'Kaizen Log'!"&TEXT(MIN(IF((COUNTIF(A\$1:A1,'Kaizen...

Aug 18, 2017 at 3:12 PM
3. ### Chirag R Raval replied to the thread COMPARE 2 COLUMNS & THAT BASED DELETE ALL EXTRA ROWS ABOVE TILL HEADING.

Dear Sir, Many Thanks ... Its in your only post no 2709 of this thread (above) ... please refer from first to understand my...

Aug 18, 2017 at 2:50 PM
4. ### Deepak Sharma replied to the thread Add amount in by changing other cell.

Wow! Instant Solutions! You guys are brilliant really! Thank you so much, Chihiro & Narayan. This was the solution I was looking for....

Aug 18, 2017 at 2:49 PM
5. ### NARAYANK991 attached a file to the thread Add amount in by changing other cell.

Hi , See if this is OK. Narayan

Aug 18, 2017 at 2:42 PM
6. ### Chihiro replied to the thread Add amount in by changing other cell.

You can just use SUMIF(s) Ex: For Received... =SUMIF(F2:F12,"Received",D2:D12) I'm not sure what you mean by below in your worksheet....

Aug 18, 2017 at 2:42 PM
7. ### vletm replied to the thread COMPARE 2 COLUMNS & THAT BASED DELETE ALL EXTRA ROWS ABOVE TILL HEADING.

Chirag R Raval You wrote: can any one help to modify this macro? There are need to "Resume Next Statement" instead of "Exit Sub" ... But...

Aug 18, 2017 at 2:42 PM
8. ### Chirag R Raval replied to the thread COMPARE 2 COLUMNS & THAT BASED DELETE ALL EXTRA ROWS ABOVE TILL HEADING.

Dear Experts, problem occurred... There are need to "Resume Next Statement" instead of "Exit Sub" please refer my attached example...

Aug 18, 2017 at 2:34 PM
9. Deepak Sharma posted a new thread.

### Add amount in by changing other cell

Hello Everyone, I need one assistance, please., I have added excel sheet. If I replace Pending as Received then amount showing in front...

#### Forum: Ask an Excel Question

Aug 18, 2017 at 2:14 PM
10. ### Chihiro replied to the thread VBA Export - New PPT File for Each Pivot Filter.

So, your table is based on OLAP. This makes looping through Filter extremely difficult and cumbersome. You should utilize...

Aug 18, 2017 at 2:12 PM
11. ### Thomas Kuriakose liked bosco_yip's post in the thread countif changes the range.

Then, changed to : =COUNTIF(OFFSET(\$A\$1,1,2,6,5),I2) Regards Bosco

Aug 18, 2017 at 1:52 PM
12. ### Thomas Kuriakose liked bosco_yip's post in the thread formula to extract text from different columns.

J33, copied down :...

Aug 18, 2017 at 1:51 PM
13. ### Thomas Kuriakose liked Chihiro's post in the thread Unique List of Names and Count Type of Project.

Glad my code was of some use ;) FYI - You don't need to set objects to nothing at the end, since VBA will purge object once process...

Aug 18, 2017 at 1:50 PM
14. ### Zaman replied to the thread Find a column based on a value in a header row and copy/paste to the adjacent cells.

Hi Yasser, I can't upload right now, no data goes out from my office computer. But i'll recreate a sample workbook once i'm at home, i'll...

Aug 18, 2017 at 1:39 PM
15. ### andrefraga27 replied to the thread Conditional Formatting in a Range.

Well, it's working the way the formula is written.

Aug 18, 2017 at 1:23 PM