• 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...

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

Dash Board to be created

T

Techtrend

Member
Hello Team

Want to create a dash board based on the conditions mentioned in the attachment
in the 2nd sheet.

Can we be able to get the results from sheet 1 to sheet 2 based on conditions only if its met using formula.

Thanks IN Advance
Satish
 

Attachments

Hi Satish,

If you have access to XL 2007+ and can use XL Tables and structural references, that will help when you start to get more data. Attached satifies what you asked, but I will warn that if you start getting into the thousands of rows, the calculation time will start to be quite noticeable.
 

Attachments

Hello Luke

There are less then 200 Rows of data and not beyond that will apply to my LIVE sheet and check.

Thank you so much
Satish
 
Hello Luke

Thanks it works,
one more favor please.

In the sheet you have mailed me,
In the dash board sheet can we highlight ONLY the symbols which are repeating.

A,H,O COL

Thanks
Satish
 
Yes, that would be doable.

First though, a question. The account for 'Techtrend' was previously owned by a 'Narendra Kumar", but I see now that the signature says "Satish". Is this the same person? Reason I ask is that Narendra contracted me for some consulting work, we agreed upon a work scope, but he never paid for the final product. :(

If this is still Narendra, I would ask that you pay the outstanding invoice (#0033). If this is someone new, do you have contact info for Narendra?
 
Hello Luke

Yes Narendra works with us,
He has Taken A different assignment NOW and travelling,

Where is the INvoice,Should we have to pay Hear.

Regards
Satish
 
Thank you Satish. The invoice was not part of Chandoo forum, this is just where he and I had met. I've sent a reminder email to: support at techtrendsolutions, in case you have access to that email account.

Attached is the currently discussed dashboard with conditional formatting applied.
 

Attachments

To fellow posters, I've not heard anything back from Satish or Narendra. While we can feel free to continue to provide free support on the forum, I would recommend not accepting any paid jobs from them. :(
 
Hello Luke

I am sorry was held up,spoke to narendra also on this project he says the work was not done and the project is still pending,After which he has been moved to a different location.

Regards
Satish
 
While that may be, I've still not been paid. Shall I wait until Narendra comes back (if ever??), or is there someone else I can email?
 
You must log in or register to reply here.
Back
Top