Welcome to the Code playground
Note that any code featured on the realce.net website is provided "As is" without any warranty of any kind, express or implied.
In no event the authors or copyright holders be liable for any claim, damages or other liability arising from, out of or in connection with the use of this content.
Please, if you are not sure of what you are doing, ask a qualified person for help.
Thank you
Filtering data in Excel
2010, Dec 21Taking a close look at your data is a key step for your data project, as a part of the preprocessing activities which often represent 80% of the workload. At first, before looking at agregate data with pivot tables, it's good practice to start looking at raw data, making selections, trying to already detect the important features. For this kind of tasks, excel filters can be pretty useful!
tags: Excel feature productivity
Do you know BrowserShots.org ?
2007, Sep 01Very Very useful site for webmasters willing to have a look at their projects viewed across multiple browsers under multiple OSes. You only need to enter the url you're willing to test and then check the different browsers versions, grouped by OS.
Its name is quite easy to remember, but you can click browsershots.org.
The MaxIf function
2007, Jul 01If you work with data in Excel, you probably already used the functions SUMIF and COUNTIF. In this post, we show how to extend it with the function MaxIf, a function written in VBA that can also be very useful.
This development example shows how VBA can help developing a custom set of function for data analysis.
tags: VBA Excel productivity
Realce.net©2000-2026 -Mentions légales-Except where indicated, this work is licensed under CC BY-NC-SA 4.0
- Page rendered in 0.2079 seconds -