1.65 score from hupso.pl for:
notjustnumbers.co.uk



HTML Content


Titlenot just numbers

Length: 16, Words: 3
Description excel tips and advice from glen feechan

Length: 39, Words: 7
Keywords pusty
Robots
Charset UTF-8
Og Meta - Title exist
Og Meta - Description exist
Og Meta - Site name pusty
Tytuł powinien zawierać pomiędzy 10 a 70 znaków (ze spacjami), a mniej niż 12 słów w długości.
Meta opis powinien zawierać pomiędzy 50 a 160 znaków (łącznie ze spacjami), a mniej niż 24 słów w długości.
Kodowanie znaków powinny być określone , UTF-8 jest chyba najlepszy zestaw znaków, aby przejść z powodu UTF-8 jest bardziej międzynarodowy kodowaniem.
Otwarte obiekty wykresu powinny być obecne w stronie internetowej (więcej informacji na temat protokołu OpenGraph: http://ogp.me/)

SEO Content

Words/Characters 3240
Text/HTML 16.53 %
Headings H1 0
H2 12
H3 4
H4 0
H5 0
H6 0
H1
H2
search not just numbers
friday, 23 december 2016
tuesday, 9 august 2016
tuesday, 5 july 2016
tuesday, 10 may 2016
hi, i'm glen feechan. welcome to my excel blog - not just numbers.
popular posts
posts by category
blog archive
other blogs you might like
about this blog
subscribe
H3
excel tip: ensuring that dropdown lists start at the top (and merry christmas)
excel tip: using logic in excel
excel tip: ranking numbers in excel
excel tip: adding up columns based on multiple criteria (the sumifs function)
H4
H5
H6
strong
email
linkedin
twitter
facebook
b
email
linkedin
twitter
facebook
i
email
linkedin
twitter
facebook
em
Bolds strong 4
b 4
i 4
em 0
Zawartość strony internetowej powinno zawierać więcej niż 250 słów, z stopa tekst / kod jest wyższy niż 20%.
Pozycji używać znaczników (h1, h2, h3, ...), aby określić temat sekcji lub ustępów na stronie, ale zwykle, użyj mniej niż 6 dla każdego tagu pozycje zachować swoją stronę zwięzły.
Styl używać silnych i kursywy znaczniki podkreślić swoje słowa kluczowe swojej stronie, ale nie nadużywać (mniej niż 16 silnych tagi i 16 znaczników kursywy)

Statystyki strony

twitter:title pusty
twitter:description pusty
google+ itemprop=name exist
Pliki zewnętrzne 23
Pliki CSS 3
Pliki javascript 20
Plik należy zmniejszyć całkowite odwołanie plików (CSS + JavaScript) do 7-8 maksymalnie.

Linki wewnętrzne i zewnętrzne

Linki 357
Linki wewnętrzne 121
Linki zewnętrzne 236
Linki bez atrybutu Title 306
Linki z atrybutem NOFOLLOW 0
Linki - Użyj atrybutu tytuł dla każdego łącza. Nofollow link jest link, który nie pozwala wyszukiwarkom boty zrealizują są odnośniki no follow. Należy zwracać uwagę na ich użytkowania

Linki wewnętrzne

- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=pagelist&widgetid=pagelist1&action=editwidget§ionid=crosscol
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=customsearch&widgetid=customsearch1&action=editwidget§ionid=main
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html6&action=editwidget§ionid=main
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html3&action=editwidget§ionid=main
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html4&action=editwidget§ionid=main
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html8&action=editwidget§ionid=sidebar-right-1
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html2&action=editwidget§ionid=sidebar-right-1
email mailto:glen@feechan.co.uk
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html5&action=editwidget§ionid=sidebar-right-1
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html9&action=editwidget§ionid=sidebar-right-1
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html1&action=editwidget§ionid=sidebar-right-1
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=popularposts&widgetid=popularposts1&action=editwidget§ionid=sidebar-right-1
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=label&widgetid=label1&action=editwidget§ionid=sidebar-right-2-1
▼  javascript:void(0)
▼  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
►  javascript:void(0)
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=blogarchive&widgetid=blogarchive1&action=editwidget§ionid=sidebar-right-2-2
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=bloglist&widgetid=bloglist1&action=editwidget§ionid=sidebar-right-3
enquiries@needaspreadsheet.com mailto:enquiries@needaspreadsheet.com
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=text&widgetid=text1&action=editwidget§ionid=sidebar-right-3
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=subscribe&widgetid=subscribe1&action=editwidget§ionid=sidebar-right-3
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=html&widgetid=html7&action=editwidget§ionid=sidebar-right-3
- //www.blogger.com/rearrange?blogid=1869924468172210809&widgettype=attribution&widgetid=attribution1&action=editwidget§ionid=footer-3

Linki zewnętrzne

- http://www.notjustnumbers.co.uk/
home http://www.notjustnumbers.co.uk/
help with excel http://www.notjustnumbers.co.uk/p/need-some-help-with-your-spreadsheet.html
online excel training http://www.notjustnumbers.co.uk/p/are-you-proficient-excel-user-our.html
learn pivot tables now... http://www.notjustnumbers.co.uk/p/would-you-like-to.html
excel tip: ensuring that dropdown lists start at the top (and merry christmas) http://www.notjustnumbers.co.uk/2016/12/excel-tip-ensuring-that-dropdown-lists.html
- https://2.bp.blogspot.com/-h6fkqadfo4i/wfz3bhbujsi/aaaaaaaapbq/vyvtjiqxr9c1sgc91lc9bno8znvwephaqclcb/s1600/santausingexcel.jpg
dropdown boxes http://www.notjustnumbers.co.uk/2009/06/excel-tip-dropdown-boxes-in-microsoft.html
- https://2.bp.blogspot.com/-dcojqpi3l_q/wf1x246fubi/aaaaaaaapbw/ev1gq94bn0so08usetek8kfhpqs3tarwgclcb/s1600/reindeerlist.png
blog http://www.notjustnumbers.co.uk/
glen feechan https://plus.google.com/102125486296079546551
17:04 http://www.notjustnumbers.co.uk/2016/12/excel-tip-ensuring-that-dropdown-lists.html
5 comments: http://www.notjustnumbers.co.uk/2016/12/excel-tip-ensuring-that-dropdown-lists.html#comment-form
- https://www.blogger.com/post-edit.g?blogid=1869924468172210809&postid=8601540577779633675&from=pencil
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=8601540577779633675&target=email
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=8601540577779633675&target=blog
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=8601540577779633675&target=twitter
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=8601540577779633675&target=facebook
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=8601540577779633675&target=pinterest
excel http://www.notjustnumbers.co.uk/search/label/excel
excel tip: using logic in excel http://www.notjustnumbers.co.uk/2016/08/excel-tip-using-logic-in-excel.html
- https://3.bp.blogspot.com/-et12gzf0i3c/v6mvpgridki/aaaaaaaansq/czeqx2hyvko3n6r04gasaa7wwoqlvak9qclcb/s1600/flowchart.jpg
if statement http://www.notjustnumbers.co.uk/2010/10/excel-tip-if-statement-made-simple.html
blog http://www.notjustnumbers.co.uk/
glen feechan https://plus.google.com/102125486296079546551
03:00 http://www.notjustnumbers.co.uk/2016/08/excel-tip-using-logic-in-excel.html
3 comments: http://www.notjustnumbers.co.uk/2016/08/excel-tip-using-logic-in-excel.html#comment-form
- https://www.blogger.com/post-edit.g?blogid=1869924468172210809&postid=3210446134271804122&from=pencil
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3210446134271804122&target=email
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3210446134271804122&target=blog
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3210446134271804122&target=twitter
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3210446134271804122&target=facebook
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3210446134271804122&target=pinterest
excel http://www.notjustnumbers.co.uk/search/label/excel
excel tip: ranking numbers in excel http://www.notjustnumbers.co.uk/2016/07/excel-tip-ranking-numbers-in-excel.html
- https://4.bp.blogspot.com/-cse1mg-buxk/v3p4tz8ehqi/aaaaaaaanac/xgb6bpe9zbssxehx5m8xv10lkgihszn2aclcb/s1600/rank.jpg
http://www.icaew.com/en/technical/information-technology/it-faculty/it-faculty-events http://www.icaew.com/en/technical/information-technology/it-faculty/it-faculty-events
- https://2.bp.blogspot.com/-pfsu59-x-mo/v3qbpvgbpyi/aaaaaaaanas/jcmjaajps3ydbcxpx2duxlqpzqfnm4wyqclcb/s1600/rankexample1.png
- https://1.bp.blogspot.com/-cjajefjmfz4/v3rjuotmz-i/aaaaaaaanbc/rbewr0qizbya6c0mk8fmfmzoxk6-f53fwclcb/s1600/rankexample2.png
countifs http://www.notjustnumbers.co.uk/2015/09/excel-tip-counting-items-that-meet.html
- https://4.bp.blogspot.com/-pfsu59-x-mo/v3qbpvgbpyi/aaaaaaaanaw/09biqlb5ajkhpjaomc3s3emkz-lkm2-mwckgb/s1600/rankexample1.png
index and match http://www.notjustnumbers.co.uk/2013/03/excel-tip-index-and-match-alternative.html
excel tip: counting items that meet certain criteria http://www.notjustnumbers.co.uk/2015/09/excel-tip-counting-items-that-meet.html
excel tip: index and match - an alternative to vlookup (and hlookup) http://www.notjustnumbers.co.uk/2013/03/excel-tip-index-and-match-alternative.html
blog http://www.notjustnumbers.co.uk/
glen feechan https://plus.google.com/102125486296079546551
03:00 http://www.notjustnumbers.co.uk/2016/07/excel-tip-ranking-numbers-in-excel.html
1 comment: http://www.notjustnumbers.co.uk/2016/07/excel-tip-ranking-numbers-in-excel.html#comment-form
- https://www.blogger.com/post-edit.g?blogid=1869924468172210809&postid=3491544019260956699&from=pencil
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3491544019260956699&target=email
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3491544019260956699&target=blog
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3491544019260956699&target=twitter
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3491544019260956699&target=facebook
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=3491544019260956699&target=pinterest
excel http://www.notjustnumbers.co.uk/search/label/excel
excel tip: adding up columns based on multiple criteria (the sumifs function) http://www.notjustnumbers.co.uk/2016/05/excel-tip-adding-up-columns-based-on.html
- https://4.bp.blogspot.com/-eozedulv5ps/vyyosb2bd0i/aaaaaaaamdy/ucng6hm59hcqqkbbgg0hjdsj4yy0ro8bwclcb/s1600/sumifs.jpg
creating excel dashboards http://www.mothresource.com/147-28-1-46.html
here http://www.mothresource.com/147-28-1-46.html
sumif http://www.notjustnumbers.co.uk/2011/07/excel-tip-using-sumif-function-to.html
- https://3.bp.blogspot.com/-nnfct7onegk/vyyxfofayei/aaaaaaaamdo/mf0704qoruqldtqbxyfxb3foivdnyav4aclcb/s1600/sumifstable.png
dollar signs http://www.notjustnumbers.co.uk/2011/05/excel-tip-dollar-sign-in-formula-fixing.html
- https://3.bp.blogspot.com/-_7irsop28jg/vyzultwkxyi/aaaaaaaamd4/kgorx-ueprmyfmtxhfu5bmhswb1ztuuhgclcb/s1600/sumifstable2.png
blog http://www.notjustnumbers.co.uk/
glen feechan https://plus.google.com/102125486296079546551
03:00 http://www.notjustnumbers.co.uk/2016/05/excel-tip-adding-up-columns-based-on.html
5 comments: http://www.notjustnumbers.co.uk/2016/05/excel-tip-adding-up-columns-based-on.html#comment-form
- https://www.blogger.com/post-edit.g?blogid=1869924468172210809&postid=2741497240015658241&from=pencil
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=2741497240015658241&target=email
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=2741497240015658241&target=blog
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=2741497240015658241&target=twitter
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=2741497240015658241&target=facebook
https://www.blogger.com/share-post.g?blogid=1869924468172210809&postid=2741497240015658241&target=pinterest
excel http://www.notjustnumbers.co.uk/search/label/excel
older posts http://www.notjustnumbers.co.uk/search?updated-max=2016-05-10t03:00:00%2b01:00&max-results=4
home http://www.notjustnumbers.co.uk/
posts (atom) http://www.notjustnumbers.co.uk/feeds/posts/default
- http://www.mothresource.com/147-28-1-47.html
- http://www.linkedin.com/in/glenfeechan
freebies http://www.notjustnumbers.co.uk/search/label/freebies
linkedin http://www.linkedin.com/in/glenfeechan
twitter http://www.twitter.com/glenfeechan
facebook http://www.facebook.com/pages/not-just-numbers/484498140293?v=wall
- http://www.mothresource.com/147-28-1-46.html
- http://www.notjustnumbers.co.uk/2011/05/excel-tip-dollar-sign-in-formula-fixing.html
excel tip: the dollar sign ($) in a formula - fixing cell references http://www.notjustnumbers.co.uk/2011/05/excel-tip-dollar-sign-in-formula-fixing.html
- http://www.notjustnumbers.co.uk/2013/06/excel-tip-quick-way-to-add-dollar-signs.html
excel tip: a quick way to add dollar signs in a formula http://www.notjustnumbers.co.uk/2013/06/excel-tip-quick-way-to-add-dollar-signs.html
- http://www.notjustnumbers.co.uk/2015/10/excel-tip-show-negative-numbers-in.html
excel tip: show negative numbers in brackets http://www.notjustnumbers.co.uk/2015/10/excel-tip-show-negative-numbers-in.html
- http://www.notjustnumbers.co.uk/2013/11/excel-tip-making-same-change-to.html
excel tip: making the same change to multiple worksheets http://www.notjustnumbers.co.uk/2013/11/excel-tip-making-same-change-to.html
- http://www.notjustnumbers.co.uk/2010/10/excel-tip-if-statement-made-simple.html
excel tip: the if statement made simple http://www.notjustnumbers.co.uk/2010/10/excel-tip-if-statement-made-simple.html
- http://www.notjustnumbers.co.uk/2015/03/excel-tip-quick-way-to-add-prefix-or.html
excel tip: a quick way to add a prefix or suffix to all cells in a list http://www.notjustnumbers.co.uk/2015/03/excel-tip-quick-way-to-add-prefix-or.html
- http://www.notjustnumbers.co.uk/2014/05/excel-tip-adding-same-cell-across.html
excel tip: adding the same cell across multiple sheets http://www.notjustnumbers.co.uk/2014/05/excel-tip-adding-same-cell-across.html
- http://www.notjustnumbers.co.uk/2014/03/excel-tip-conditional-formatting-based.html
excel tip: conditional formatting based on other cells http://www.notjustnumbers.co.uk/2014/03/excel-tip-conditional-formatting-based.html
- http://www.notjustnumbers.co.uk/2015/01/excel-tip-have-your-buttons-stopped.html
excel tip: have your buttons stopped working? http://www.notjustnumbers.co.uk/2015/01/excel-tip-have-your-buttons-stopped.html
- http://www.notjustnumbers.co.uk/2012/11/excel-tip-using-data-in-sentences.html
excel tip: using data in sentences http://www.notjustnumbers.co.uk/2012/11/excel-tip-using-data-in-sentences.html
accounting http://www.notjustnumbers.co.uk/search/label/accounting
art http://www.notjustnumbers.co.uk/search/label/art
banking http://www.notjustnumbers.co.uk/search/label/banking
cost-saving http://www.notjustnumbers.co.uk/search/label/cost-saving
credit crunch http://www.notjustnumbers.co.uk/search/label/credit%20crunch
events http://www.notjustnumbers.co.uk/search/label/events
excel http://www.notjustnumbers.co.uk/search/label/excel
freebies http://www.notjustnumbers.co.uk/search/label/freebies
general comments http://www.notjustnumbers.co.uk/search/label/general%20comments
guest articles http://www.notjustnumbers.co.uk/search/label/guest%20articles
notjustnumbers http://www.notjustnumbers.co.uk/search/label/notjustnumbers
obama http://www.notjustnumbers.co.uk/search/label/obama
pivot tables http://www.notjustnumbers.co.uk/search/label/pivot%20tables
recession http://www.notjustnumbers.co.uk/search/label/recession
reporting http://www.notjustnumbers.co.uk/search/label/reporting
social media http://www.notjustnumbers.co.uk/search/label/social%20media
vat http://www.notjustnumbers.co.uk/search/label/vat
2016 http://www.notjustnumbers.co.uk/search?updated-min=2016-01-01t00:00:00z&updated-max=2017-01-01t00:00:00z&max-results=8
december http://www.notjustnumbers.co.uk/2016_12_01_archive.html
excel tip: ensuring that dropdown lists start at t... http://www.notjustnumbers.co.uk/2016/12/excel-tip-ensuring-that-dropdown-lists.html
august http://www.notjustnumbers.co.uk/2016_08_01_archive.html
july http://www.notjustnumbers.co.uk/2016_07_01_archive.html
may http://www.notjustnumbers.co.uk/2016_05_01_archive.html
april http://www.notjustnumbers.co.uk/2016_04_01_archive.html
march http://www.notjustnumbers.co.uk/2016_03_01_archive.html
february http://www.notjustnumbers.co.uk/2016_02_01_archive.html
january http://www.notjustnumbers.co.uk/2016_01_01_archive.html
2015 http://www.notjustnumbers.co.uk/search?updated-min=2015-01-01t00:00:00z&updated-max=2016-01-01t00:00:00z&max-results=39
december http://www.notjustnumbers.co.uk/2015_12_01_archive.html
november http://www.notjustnumbers.co.uk/2015_11_01_archive.html
october http://www.notjustnumbers.co.uk/2015_10_01_archive.html
september http://www.notjustnumbers.co.uk/2015_09_01_archive.html
august http://www.notjustnumbers.co.uk/2015_08_01_archive.html
july http://www.notjustnumbers.co.uk/2015_07_01_archive.html
june http://www.notjustnumbers.co.uk/2015_06_01_archive.html
may http://www.notjustnumbers.co.uk/2015_05_01_archive.html
april http://www.notjustnumbers.co.uk/2015_04_01_archive.html
march http://www.notjustnumbers.co.uk/2015_03_01_archive.html
february http://www.notjustnumbers.co.uk/2015_02_01_archive.html
january http://www.notjustnumbers.co.uk/2015_01_01_archive.html
2014 http://www.notjustnumbers.co.uk/search?updated-min=2014-01-01t00:00:00z&updated-max=2015-01-01t00:00:00z&max-results=48
december http://www.notjustnumbers.co.uk/2014_12_01_archive.html
november http://www.notjustnumbers.co.uk/2014_11_01_archive.html
october http://www.notjustnumbers.co.uk/2014_10_01_archive.html
september http://www.notjustnumbers.co.uk/2014_09_01_archive.html
august http://www.notjustnumbers.co.uk/2014_08_01_archive.html
july http://www.notjustnumbers.co.uk/2014_07_01_archive.html
june http://www.notjustnumbers.co.uk/2014_06_01_archive.html
may http://www.notjustnumbers.co.uk/2014_05_01_archive.html
april http://www.notjustnumbers.co.uk/2014_04_01_archive.html
march http://www.notjustnumbers.co.uk/2014_03_01_archive.html
february http://www.notjustnumbers.co.uk/2014_02_01_archive.html
january http://www.notjustnumbers.co.uk/2014_01_01_archive.html
2013 http://www.notjustnumbers.co.uk/search?updated-min=2013-01-01t00:00:00z&updated-max=2014-01-01t00:00:00z&max-results=50
december http://www.notjustnumbers.co.uk/2013_12_01_archive.html
november http://www.notjustnumbers.co.uk/2013_11_01_archive.html
october http://www.notjustnumbers.co.uk/2013_10_01_archive.html
september http://www.notjustnumbers.co.uk/2013_09_01_archive.html
august http://www.notjustnumbers.co.uk/2013_08_01_archive.html
july http://www.notjustnumbers.co.uk/2013_07_01_archive.html
june http://www.notjustnumbers.co.uk/2013_06_01_archive.html
may http://www.notjustnumbers.co.uk/2013_05_01_archive.html
april http://www.notjustnumbers.co.uk/2013_04_01_archive.html
march http://www.notjustnumbers.co.uk/2013_03_01_archive.html
february http://www.notjustnumbers.co.uk/2013_02_01_archive.html
january http://www.notjustnumbers.co.uk/2013_01_01_archive.html
2012 http://www.notjustnumbers.co.uk/search?updated-min=2012-01-01t00:00:00z&updated-max=2013-01-01t00:00:00z&max-results=21
december http://www.notjustnumbers.co.uk/2012_12_01_archive.html
november http://www.notjustnumbers.co.uk/2012_11_01_archive.html
october http://www.notjustnumbers.co.uk/2012_10_01_archive.html
september http://www.notjustnumbers.co.uk/2012_09_01_archive.html
july http://www.notjustnumbers.co.uk/2012_07_01_archive.html
june http://www.notjustnumbers.co.uk/2012_06_01_archive.html
april http://www.notjustnumbers.co.uk/2012_04_01_archive.html
march http://www.notjustnumbers.co.uk/2012_03_01_archive.html
february http://www.notjustnumbers.co.uk/2012_02_01_archive.html
january http://www.notjustnumbers.co.uk/2012_01_01_archive.html
2011 http://www.notjustnumbers.co.uk/search?updated-min=2011-01-01t00:00:00z&updated-max=2012-01-01t00:00:00z&max-results=15
december http://www.notjustnumbers.co.uk/2011_12_01_archive.html
august http://www.notjustnumbers.co.uk/2011_08_01_archive.html
july http://www.notjustnumbers.co.uk/2011_07_01_archive.html
june http://www.notjustnumbers.co.uk/2011_06_01_archive.html
may http://www.notjustnumbers.co.uk/2011_05_01_archive.html
march http://www.notjustnumbers.co.uk/2011_03_01_archive.html
january http://www.notjustnumbers.co.uk/2011_01_01_archive.html
2010 http://www.notjustnumbers.co.uk/search?updated-min=2010-01-01t00:00:00z&updated-max=2011-01-01t00:00:00z&max-results=33
december http://www.notjustnumbers.co.uk/2010_12_01_archive.html
november http://www.notjustnumbers.co.uk/2010_11_01_archive.html
october http://www.notjustnumbers.co.uk/2010_10_01_archive.html
september http://www.notjustnumbers.co.uk/2010_09_01_archive.html
august http://www.notjustnumbers.co.uk/2010_08_01_archive.html
june http://www.notjustnumbers.co.uk/2010_06_01_archive.html
may http://www.notjustnumbers.co.uk/2010_05_01_archive.html
april http://www.notjustnumbers.co.uk/2010_04_01_archive.html
march http://www.notjustnumbers.co.uk/2010_03_01_archive.html
february http://www.notjustnumbers.co.uk/2010_02_01_archive.html
january http://www.notjustnumbers.co.uk/2010_01_01_archive.html
2009 http://www.notjustnumbers.co.uk/search?updated-min=2009-01-01t00:00:00z&updated-max=2010-01-01t00:00:00z&max-results=50
december http://www.notjustnumbers.co.uk/2009_12_01_archive.html
november http://www.notjustnumbers.co.uk/2009_11_01_archive.html
october http://www.notjustnumbers.co.uk/2009_10_01_archive.html
september http://www.notjustnumbers.co.uk/2009_09_01_archive.html
august http://www.notjustnumbers.co.uk/2009_08_01_archive.html
july http://www.notjustnumbers.co.uk/2009_07_01_archive.html
june http://www.notjustnumbers.co.uk/2009_06_01_archive.html
may http://www.notjustnumbers.co.uk/2009_05_01_archive.html
april http://www.notjustnumbers.co.uk/2009_04_01_archive.html
march http://www.notjustnumbers.co.uk/2009_03_01_archive.html
february http://www.notjustnumbers.co.uk/2009_02_01_archive.html
january http://www.notjustnumbers.co.uk/2009_01_01_archive.html
2008 http://www.notjustnumbers.co.uk/search?updated-min=2008-01-01t00:00:00z&updated-max=2009-01-01t00:00:00z&max-results=32
december http://www.notjustnumbers.co.uk/2008_12_01_archive.html
november http://www.notjustnumbers.co.uk/2008_11_01_archive.html
october http://www.notjustnumbers.co.uk/2008_10_01_archive.html
september http://www.notjustnumbers.co.uk/2008_09_01_archive.html
pointy haired dilbert: charting & excel tips - chandoo.org http://chandoo.org/wp
get rid of that ugly formatting with two simple tricks http://feedproxy.google.com/~r/pointyhaireddilbert/~3/kkvzzdhdrb4/
videos and accounting http://askm-videos.blogspot.com/
in praise of university for future business owners http://feedproxy.google.com/~r/videosandaccounting/~3/z5bvmht6n5s/in-praise-of-university-for-future.html
accountingweb.co.uk http://www.accountingweb.co.uk/rss/feeds/news.xml
accman pro http://feeds.feedburner.com/flacknhack/jrao
manufacturing times blog http://manufacturingtimes.co.uk/feed/
needaspreadsheet.com http://www.needaspreadsheet.com/
needaspreadsheet.com http://www.needaspreadsheet.com/
- https://www.netvibes.com/subscribe.php?url=http%3a%2f%2fwww.notjustnumbers.co.uk%2ffeeds%2fposts%2fdefault
- https://add.my.yahoo.com/content?url=http%3a%2f%2fwww.notjustnumbers.co.uk%2ffeeds%2fposts%2fdefault
- atom http://www.notjustnumbers.co.uk/feeds/posts/default
- https://www.netvibes.com/subscribe.php?url=http%3a%2f%2fwww.notjustnumbers.co.uk%2ffeeds%2fcomments%2fdefault
- https://add.my.yahoo.com/content?url=http%3a%2f%2fwww.notjustnumbers.co.uk%2ffeeds%2fcomments%2fdefault
- atom http://www.notjustnumbers.co.uk/feeds/comments/default
- http://www.kashflow.com/?code=feechan
blogger https://www.blogger.com

Zdjęcia

Zdjęcia 61
Zdjęcia bez atrybutu ALT 56
Zdjęcia bez atrybutu TITLE 61
Korzystanie Obraz ALT i TITLE atrybutu dla każdego obrazu.

Zdjęcia bez atrybutu TITLE

http://2.bp.blogspot.com/-1mg7pujss8u/wcttbyeb7vi/aaaaaaaao28/n4tltspvnk0vtzu8pnvnj5w7urbij9xoack4b/s1600/notjustnumbersbannernew.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://2.bp.blogspot.com/-h6fkqadfo4i/wfz3bhbujsi/aaaaaaaapbq/vyvtjiqxr9c1sgc91lc9bno8znvwephaqclcb/s320/santausingexcel.jpg
https://2.bp.blogspot.com/-dcojqpi3l_q/wf1x246fubi/aaaaaaaapbw/ev1gq94bn0so08usetek8kfhpqs3tarwgclcb/s320/reindeerlist.png
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://3.bp.blogspot.com/-et12gzf0i3c/v6mvpgridki/aaaaaaaansq/czeqx2hyvko3n6r04gasaa7wwoqlvak9qclcb/s320/flowchart.jpg
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://4.bp.blogspot.com/-cse1mg-buxk/v3p4tz8ehqi/aaaaaaaanac/xgb6bpe9zbssxehx5m8xv10lkgihszn2aclcb/s320/rank.jpg
https://2.bp.blogspot.com/-pfsu59-x-mo/v3qbpvgbpyi/aaaaaaaanas/jcmjaajps3ydbcxpx2duxlqpzqfnm4wyqclcb/s320/rankexample1.png
https://1.bp.blogspot.com/-cjajefjmfz4/v3rjuotmz-i/aaaaaaaanbc/rbewr0qizbya6c0mk8fmfmzoxk6-f53fwclcb/s320/rankexample2.png
https://4.bp.blogspot.com/-pfsu59-x-mo/v3qbpvgbpyi/aaaaaaaanaw/09biqlb5ajkhpjaomc3s3emkz-lkm2-mwckgb/s320/rankexample1.png
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://4.bp.blogspot.com/-eozedulv5ps/vyyosb2bd0i/aaaaaaaamdy/ucng6hm59hcqqkbbgg0hjdsj4yy0ro8bwclcb/s320/sumifs.jpg
https://3.bp.blogspot.com/-nnfct7onegk/vyyxfofayei/aaaaaaaamdo/mf0704qoruqldtqbxyfxb3foivdnyav4aclcb/s320/sumifstable.png
https://3.bp.blogspot.com/-_7irsop28jg/vyzultwkxyi/aaaaaaaamd4/kgorx-ueprmyfmtxhfu5bmhswb1ztuuhgclcb/s320/sumifstable2.png
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
http://www.mothresource.com/idevaffiliate/banners/webinar_473x61.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
http://www.needaspreadsheet.com/wp-content/uploads/2012/06/glenfeechansmall.jpg
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
http://www.mothresource.com/idevaffiliate/banners/webinar_300x250.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
http://3.bp.blogspot.com/-ayjb-6r0se0/tdy24fxd6qi/aaaaaaaaaa0/vw22e_0znd4/w72-h72-p-k-nu/dollar+signs.jpg
http://2.bp.blogspot.com/-m-6975yaysa/uayhixg1xsi/aaaaaaaabtw/h408skz9yxw/w72-h72-p-k-nu/quick+dollar+signs.jpg
http://4.bp.blogspot.com/-jf7zsgs--wc/vhv_gvtm_mi/aaaaaaaakds/zffcn6k1xva/w72-h72-p-k-nu/brackets.jpg
http://3.bp.blogspot.com/-l59trjlilcu/uo97ksnp3ji/aaaaaaaab9u/w2jfpzgabpa/w72-h72-p-k-nu/multiple+changes.jpg
http://4.bp.blogspot.com/_76aiwnjnsck/tl9h5xc3whi/aaaaaaaaagq/2s_quanbeb0/w72-h72-p-k-nu/cointossanimated.gif
http://2.bp.blogspot.com/-yvrkoiljgys/vpsamckcczi/aaaaaaaahqc/vfjiewhpfm0/w72-h72-p-k-nu/eraser.jpg
http://4.bp.blogspot.com/-mub5i_gctp8/u3ppbxmn6qi/aaaaaaaacmu/tz_xcmpjuba/w72-h72-p-k-nu/multiple+sheets.jpg
http://4.bp.blogspot.com/-g2atg4svetm/uxspslfrlpi/aaaaaaaacfe/m8za9g1dede/w72-h72-p-k-nu/traffic+lights.jpg
http://1.bp.blogspot.com/-lcyfvay7kyy/vl0uenrcthi/aaaaaaaahj8/9-xknbgiius/w72-h72-p-k-nu/buttonfix.jpg
http://1.bp.blogspot.com/-d1qjrskwx3u/ukfexff76xi/aaaaaaaabia/ydy3xlj0oc4/w72-h72-p-k-nu/upperlowercaseletters.jpg
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://img1.blogblog.com/img/widgets/subscribe-netvibes.png
https://img1.blogblog.com/img/widgets/subscribe-yahoo.png
https://img1.blogblog.com/img/icon_feed12.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://img1.blogblog.com/img/widgets/subscribe-netvibes.png
https://img1.blogblog.com/img/widgets/subscribe-yahoo.png
https://img1.blogblog.com/img/icon_feed12.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
http://www.kashflow.com/images/bans/145x109.gif
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png

Zdjęcia bez atrybutu ALT

https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://2.bp.blogspot.com/-h6fkqadfo4i/wfz3bhbujsi/aaaaaaaapbq/vyvtjiqxr9c1sgc91lc9bno8znvwephaqclcb/s320/santausingexcel.jpg
https://2.bp.blogspot.com/-dcojqpi3l_q/wf1x246fubi/aaaaaaaapbw/ev1gq94bn0so08usetek8kfhpqs3tarwgclcb/s320/reindeerlist.png
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://3.bp.blogspot.com/-et12gzf0i3c/v6mvpgridki/aaaaaaaansq/czeqx2hyvko3n6r04gasaa7wwoqlvak9qclcb/s320/flowchart.jpg
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://4.bp.blogspot.com/-cse1mg-buxk/v3p4tz8ehqi/aaaaaaaanac/xgb6bpe9zbssxehx5m8xv10lkgihszn2aclcb/s320/rank.jpg
https://2.bp.blogspot.com/-pfsu59-x-mo/v3qbpvgbpyi/aaaaaaaanas/jcmjaajps3ydbcxpx2duxlqpzqfnm4wyqclcb/s320/rankexample1.png
https://1.bp.blogspot.com/-cjajefjmfz4/v3rjuotmz-i/aaaaaaaanbc/rbewr0qizbya6c0mk8fmfmzoxk6-f53fwclcb/s320/rankexample2.png
https://4.bp.blogspot.com/-pfsu59-x-mo/v3qbpvgbpyi/aaaaaaaanaw/09biqlb5ajkhpjaomc3s3emkz-lkm2-mwckgb/s320/rankexample1.png
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://4.bp.blogspot.com/-eozedulv5ps/vyyosb2bd0i/aaaaaaaamdy/ucng6hm59hcqqkbbgg0hjdsj4yy0ro8bwclcb/s320/sumifs.jpg
https://3.bp.blogspot.com/-nnfct7onegk/vyyxfofayei/aaaaaaaamdo/mf0704qoruqldtqbxyfxb3foivdnyav4aclcb/s320/sumifstable.png
https://3.bp.blogspot.com/-_7irsop28jg/vyzultwkxyi/aaaaaaaamd4/kgorx-ueprmyfmtxhfu5bmhswb1ztuuhgclcb/s320/sumifstable2.png
https://resources.blogblog.com/img/icon18_edit_allbkg.gif
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
http://3.bp.blogspot.com/-ayjb-6r0se0/tdy24fxd6qi/aaaaaaaaaa0/vw22e_0znd4/w72-h72-p-k-nu/dollar+signs.jpg
http://2.bp.blogspot.com/-m-6975yaysa/uayhixg1xsi/aaaaaaaabtw/h408skz9yxw/w72-h72-p-k-nu/quick+dollar+signs.jpg
http://4.bp.blogspot.com/-jf7zsgs--wc/vhv_gvtm_mi/aaaaaaaakds/zffcn6k1xva/w72-h72-p-k-nu/brackets.jpg
http://3.bp.blogspot.com/-l59trjlilcu/uo97ksnp3ji/aaaaaaaab9u/w2jfpzgabpa/w72-h72-p-k-nu/multiple+changes.jpg
http://4.bp.blogspot.com/_76aiwnjnsck/tl9h5xc3whi/aaaaaaaaagq/2s_quanbeb0/w72-h72-p-k-nu/cointossanimated.gif
http://2.bp.blogspot.com/-yvrkoiljgys/vpsamckcczi/aaaaaaaahqc/vfjiewhpfm0/w72-h72-p-k-nu/eraser.jpg
http://4.bp.blogspot.com/-mub5i_gctp8/u3ppbxmn6qi/aaaaaaaacmu/tz_xcmpjuba/w72-h72-p-k-nu/multiple+sheets.jpg
http://4.bp.blogspot.com/-g2atg4svetm/uxspslfrlpi/aaaaaaaacfe/m8za9g1dede/w72-h72-p-k-nu/traffic+lights.jpg
http://1.bp.blogspot.com/-lcyfvay7kyy/vl0uenrcthi/aaaaaaaahj8/9-xknbgiius/w72-h72-p-k-nu/buttonfix.jpg
http://1.bp.blogspot.com/-d1qjrskwx3u/ukfexff76xi/aaaaaaaabia/ydy3xlj0oc4/w72-h72-p-k-nu/upperlowercaseletters.jpg
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://img1.blogblog.com/img/widgets/subscribe-netvibes.png
https://img1.blogblog.com/img/widgets/subscribe-yahoo.png
https://img1.blogblog.com/img/icon_feed12.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://img1.blogblog.com/img/widgets/subscribe-netvibes.png
https://img1.blogblog.com/img/widgets/subscribe-yahoo.png
https://img1.blogblog.com/img/icon_feed12.png
https://img2.blogblog.com/img/widgets/arrow_dropdown.gif
https://img1.blogblog.com/img/icon_feed12.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png
https://resources.blogblog.com/img/icon18_wrench_allbkg.png

Ranking:


Alexa Traffic
Daily Global Rank Trend
Daily Reach (Percent)









Majestic SEO











Text on page:

home help with excel online excel training learn pivot tables now... search not just numbers loading... friday, 23 december 2016 excel tip: ensuring that dropdown lists start at the top (and merry christmas) before i start this post, i must first apologise for the lack of posts over recent months. after returning from my summer holidays, my workload hasn't really eased (which isn't a bad thing), and my blogging has suffered. i wanted to get an (albeit short) tip up before christmas, though, and it is one of my new year resolutions to post at least once a month in 2017. your christmas tip then is a simple answer to a particularly annoying aspect of data validation dropdown boxes. a feature of data validation drodpown lists in excel is that if the cell already contains a value from the list, the dropdown starts with that value selected, and you need to scroll up if you want to select an earlier value. this is normally fine except for the following (very common) scenario. it is good practice to have the dropdown list look at a range where its entries can be edited, and to leave space at the bottom of the list to allow the list to be added to. however, a side-effect of this is that, when your cell is empty, the dropdown will start at the bottom of the list, as it sees the empty cells at the bottom as a match for the current entry (nothing). the simplest answer i have found to this is to have a blank cell at the top of the list as well. as this matching feature matches the first match it finds, your dropdown list will now start at the top (for an empty cell). i often find the neatest way to do this is to have a blank row under the headers that doesn't look like part of the list: in the example above, we could use the range a2:a14 to drive the dropdown list and cell a2 would be the first match for a blank cell, rather than a12. that's it for now, and 2016! may you and your family have a great, safe and merry christmas (or whatever holiday you celebrate) and a fantastic 2017. if you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "the 5 excel features that you need to know" and "30 chants for better charts". posted by glen feechan at 17:04 5 comments: email thisblogthis!share to twittershare to facebookshare to pinterest labels: excel tuesday, 9 august 2016 excel tip: using logic in excel logic (particularly boolean logic) plays a huge rule in computer programming and circuitry, but is also very useful in excel. it is fundamental to the if statement which in itself is such an important tool in excel, but has many other roles. essentially, when we talk about logic in this context, we are talking about expressions that can either be true or false, e.g. a1=100 b5<=34 c2="yes" you can simply type the expression as a formula in a cell putting an "=" in front of it, so if you enter: =a1=100 into, say, cell b1, then cell b1 will show the word true if a1 is 100 and the word false otherwise. as mentioned earlier, one of the more common places to use these expressions is in an if statement, which works as follows: =if(expression,value to return if expression is true,value to return if expression is false) e.g. =if(a1=100,"yes","no") will return yes if a1 is 100 and no if not. some logical functions there are a few logical functions which extend the possibilities, in particular we will look at not, and and or. not reverses the result of a logical expression. if =a1=100 returns true, then =not(a1=100) returns false, and vice versa. and allows you to list multiple expressions and returns true only if all of the expressions would individually return true. otherwise it returns false. or works the same but returns true if any of the expressions are true. e.g. =and(a1=100,b5<=34,c2="yes") will only return true, if all three of those statements are true. whereas: =or(a1=100,b5<=34,c2="yes") will return true if any of the three conditions are true. by using this type of logical expression, particularly within an if statement, or a conditional formatting condition, we can control how a spreadsheet both looks and calculates based upon the content of cells. if you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "the 5 excel features that you need to know" and "30 chants for better charts". posted by glen feechan at 03:00 3 comments: email thisblogthis!share to twittershare to facebookshare to pinterest labels: excel tuesday, 5 july 2016 excel tip: ranking numbers in excel before i start, a couple of announcements. first of all, please accept my apologies for the time between posts. a combination of workload and a family bereavement have slowed me down somewhat! secondly, if any of you will be in and around london tomorrow (wednesday) night, the icaew are launching their spreadsheet competency framework, with some top speakers from the world of excel. this document (as suggested by its name) is intended to provide a framework to assess spreadsheet competency, and was developed by the institute's excel community advisory committee, of which i am a member. the event is free to attend, and further details can be found at: http://www.icaew.com/en/technical/information-technology/it-faculty/it-faculty-events i hope to see you there. right...on with the post. there are many reasons, you might want to rank a list of numbers in excel. one i do quite often, is produce a league table. by calculating the ranking of a number and then using lookups to populate a table in rank order, we can easily produce a league table, like the example below: the first rank column is the one we are trying to populate here. in excel 2010 onwards we will use the rank.eq function, which replaces the rank function in excel 2007 and before. both functions work exactly the same, and both exist in excel 2010 to 2016, at least. if you know you may have users using excel 2007 or earlier, use the rank function - otherwise use rank.eq to future-proof your spreadsheet. the rank.eq (or indeed the rank) function's syntax is as follows: =rank.eq(number,ref,[order]) where: number is the number we want to know the rank of ref is the whole range of numbers order is an optional argument, which determines the order that the numbers should be ranked in. if this argument is zero, or omitted, the numbers are ranked in descending order (the largest number is ranked 1), whereas if this is 1 (or any non-zero value), the numbers are ranked in ascending order. where two numbers in the range are the same, they are both given the highest rank (when using the rank.eq function - there is a similar rank.avg function that gives them their average rank). in our example the numbers 30,45,97, etc. are in the range b3:b12, so we would use the rank.eq function in cells c3:c12. in cell c3, we would enter: =rank.eq($b3,$b$3:$b$12) notice that we have fixed all of the references (using the dollar signs) on the b3:b12 range, to ensure that this range stays fixed when we copy it down, but just the column on the b3 reference so that the row (and the number we rank) changes as we copy down. if we use this function as it is, we will run into a problem, though. as there are two number 24s in our range, we get the following: notice that both 24s are ranked 8 (the highest rank), which means there is no rank 9 - hence our error in the league table when we try to look up 9. we need each rank to be unique for our league table to work. we will need to use another formula to address this, and we can use countifs to count how many instances have occurred so far in the list.and if this is greater than 1, to add the difference to the rank. our formula becomes: =rank.eq($b3,$b$3:$b$12)+countifs($b$3:$b3,$b3)-1 notice that in the criteria range b3:b3, i have fixed the row on the start of the range and left it flexible on the end, so when our formula is copied down, we are always counting the instances from the top of the column to the current row. by the end of the range, our formula is: =rank.eq($b12,$b$3:$b$12)+countifs($b$3:$b12,$b12)-1 on the first 24, our rank.eq function returns 8 as before, and our countifs counts that there is 1 24 so far, so: 8+1-1 = 8 on the second 24, our rank.eq function again returns 8, but our countifs now counts that there are two 24s so far, so: 8+2-1 = 9 thereby giving us the result we required: the league table was created by entering the numbers 1 to 10 in the first column and using index and match to return the number at that rank from the first table. the index/match function on the first row (row 3) was: =index($b$3:$b$12,match($e3,$c$3:$c$12,0)) if you did not understand the countifs or index/match functions, please visit these earlier posts: excel tip: counting items that meet certain criteria excel tip: index and match - an alternative to vlookup (and hlookup) if you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "the 5 excel features that you need to know" and "30 chants for better charts". posted by glen feechan at 03:00 1 comment: email thisblogthis!share to twittershare to facebookshare to pinterest labels: excel tuesday, 10 may 2016 excel tip: adding up columns based on multiple criteria (the sumifs function) before getting into today's post i want to point you to an excellent free webinar being offered (for a limited time) by mynda treacy, entitled "creating excel dashboards". mynda is a real expert on excel dashboards and her training materials are always excellent. you can register for the webinar here. i realised the other day that i had never covered one of my most used functions on this blog - sumifs. i have covered its predecessor, sumif, as sumifs has only been available since excel 2007. although sumif is still available in later versions of excel for compatibility purposes, it is essentially redundant, as sumifs does the same thing, plus a lot more. let us look at an example of some sales data (see left). say we want to know how much mary's sales were, or how much sarah sold in the east region, or even how much ben sold in the north region in the month of january. sumifs can do all of these. the syntax for sumifs is as follows: =sumifs(sumrange,criteriarange1,criteria1,[criteriarange2],[criteria2].....) you can have as many pairs of criteriarange and criteria as you need. the function works as follows: sum sumrange where criteriarange1 = criteria1 and criteriarange2 = criteria2 etc. for however many criteria you have. for all of the examples above the sumrange will be d2:d21, as this is the range we want to sum, subject to our criteria. we will look at how we construct the rest of the formula for each of our examples above. how much did mary sell? here we only have one criteria: criteriarange1 = c2:c21 criteria1 = "mary" =sumifs(d2:d21,c2:c21,"mary") returns £16,853. how much did sarah sell in the east region? this time we have two criteria: criteriarange1 = c2:c21 criteria1 = "sarah" criteriarange2 = b2:b21 criteria2 = "east" =sumifs(d2:d21,c2:c21,"sarah",b2:b21,"east") returns £1,085. how much did ben sell in the north region in the month of january? this time we actually have four criteria: criteriarange1 = c2:c21 criteria1 = "ben" criteriarange2 = b2:b21 criteria2 = "north" criteriarange3 = a2:a21 criteria3 = ">="&date(2016,1,1) criteriarange4 = a2:a21 criteria4 = "<="&date(2016,1,31) there are two elements to these last two criteria that need further explanation. the first is that if our criteria is anything other than equals, we need to include the criteria in inverted commas, for example ">23", or "<=15", to make it a string. if rather than 23, we wished to refer to a cell (say g5) we can use the ampersand (&) to join two strings together, e.g. ">"&g5. the second is that if we wish to refer to a date directly, we need to refer its sequential number which we can calculate using the date function. the three arguments for the date function are year, month and day, so to get the date sequence number for 1st january 2016, we can use date(2016,1,1). note that if we entered 1/1/2016 in cell g5, we could just use ">="&g5 for criteria3, as the cell value when you enter a date, is its date sequence value. our function is therefore: =sumifs(d2:d21,c2:c21,"ben",b2:b21,"north",a2:a21,">="&date(2016,1,1),a2:a21,"<="&date(2016,1,31)) which returns £4,007. in most real situations we are likely to have all of the criteria in other cells, as we are usually doing more than one calculation. with careful planning and smart use of dollar signs, you can structure your formula so that you only need to write it once. for example if we wish to populate the following grid from our data: if we put the following function in cell j2, we can copy it to all of the other cells: =sumifs($d$2:$d$21,$c$2:$c$21,$i2,$b$2:$b$21,j$1) we have used dollars to fix both the rows and columns of the references to the data table, as these should not change, no matter what cell that we are in. for our criteria however, we want those to change between cells, so we have fixed the column of our name criteria ($i2), as we are always going to look to column i for the name, but want it to change as we change rows. similarly, we have fixed the row of our region criteria (j$1), as we always want to look at row 1, but want it to change with the columns. hopefully this gives you an idea how flexible sumifs can be. if you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "the 5 excel features that you need to know" and "30 chants for better charts". posted by glen feechan at 03:00 5 comments: email thisblogthis!share to twittershare to facebookshare to pinterest labels: excel older posts home subscribe to: posts (atom) hi, i'm glen feechan. welcome to my excel blog - not just numbers. i aim to provide practical excel tips to those using excel in their day-to-day jobs. i am a chartered accountant who has used excel for too many years to remember, and now focus my efforts on helping others to get the most out of this powerful tool. you can sign up (above) and get a free report and regular updates of new posts to the blog. also have a look at the freebies section for free training videos, etc. i hope you find the content useful and that every now and again it makes you smile. glen feechan email linkedin twitter facebook popular posts excel tip: the dollar sign ($) in a formula - fixing cell references i want to cover something today that i use all of the time but seems to be understood in varying degrees by clients i work with. i am t... excel tip: a quick way to add dollar signs in a formula last week, i posted a really simple tip for copying down a formula to the bottom of your data . this turned out to be one of my most po... excel tip: show negative numbers in brackets working with accountants, one of the requirements i often get asked for, is to show negative numbers in brackets. surprisingly, this is... excel tip: making the same change to multiple worksheets sometimes we build an excel spreadsheet that has a number of worksheets (or tabs) that are the same layout. no matter how well we have ... excel tip: the if statement made simple one of the functions i use most often in excel is the if statement. this function is very powerful and to many can seem very complicated... excel tip: a quick way to add a prefix or suffix to all cells in a list do you ever have those situations where you need to make an amendment to the text in every cell in a range? i know it is an issue i com... excel tip: adding the same cell across multiple sheets have you ever needed to sum the same cell across multiple sheets? you might have 12 monthly sheets and an annual summary or 26 departme... excel tip: conditional formatting based on other cells excel's conditional formatting feature typically allows you to set the format of a cell based upon its contents, and allows you to de... excel tip: have your buttons stopped working? today's post refers to a problem that started occurring in early december but i have had a number of clients raise the problem in rec... excel tip: using data in sentences microsoft office users will tend to use excel to handle numbers and data, and word to handle text - which, of course, is how it should be... posts by category accounting (23) art (1) banking (13) cost-saving (16) credit crunch (11) events (8) excel (229) freebies (14) general comments (51) guest articles (14) notjustnumbers (31) obama (2) pivot tables (28) recession (19) reporting (22) social media (5) vat (3) blog archive ▼  2016 (8) ▼  december (1) excel tip: ensuring that dropdown lists start at t... ►  august (1) ►  july (1) ►  may (1) ►  april (1) ►  march (1) ►  february (1) ►  january (1) ►  2015 (39) ►  december (2) ►  november (1) ►  october (2) ►  september (5) ►  august (2) ►  july (2) ►  june (4) ►  may (4) ►  april (4) ►  march (5) ►  february (4) ►  january (4) ►  2014 (48) ►  december (3) ►  november (4) ►  october (4) ►  september (5) ►  august (2) ►  july (5) ►  june (4) ►  may (4) ►  april (5) ►  march (4) ►  february (4) ►  january (4) ►  2013 (53) ►  december (5) ►  november (4) ►  october (5) ►  september (4) ►  august (4) ►  july (5) ►  june (4) ►  may (4) ►  april (5) ►  march (4) ►  february (4) ►  january (5) ►  2012 (21) ►  december (3) ►  november (3) ►  october (2) ►  september (1) ►  july (3) ►  june (2) ►  april (2) ►  march (1) ►  february (2) ►  january (2) ►  2011 (15) ►  december (3) ►  august (1) ►  july (3) ►  june (1) ►  may (3) ►  march (1) ►  january (3) ►  2010 (33) ►  december (1) ►  november (3) ►  october (3) ►  september (2) ►  august (2) ►  june (5) ►  may (3) ►  april (1) ►  march (4) ►  february (4) ►  january (5) ►  2009 (79) ►  december (2) ►  november (6) ►  october (5) ►  september (6) ►  august (2) ►  july (1) ►  june (5) ►  may (5) ►  april (13) ►  march (9) ►  february (11) ►  january (14) ►  2008 (32) ►  december (6) ►  november (19) ►  october (3) ►  september (4) other blogs you might like pointy haired dilbert: charting & excel tips - chandoo.org get rid of that ugly formatting with two simple tricks - *we are on a tiki tour around nz. *so far we have been to taupo & rotorua. and we are doing what you do when you are on a holiday - being lazy, going on wa... 18 hours ago videos and accounting in praise of university for future business owners - simon dolan has put forward the case that a university degree is "a waste of time" for the "vast majority", and urges young people to start their own busin... 3 years ago accountingweb.co.uk - accman pro - manufacturing times blog - about this blog not just numbers is sponsored by: needaspreadsheet.com 53 dawlish closeseahamcounty durhamsr7 8deuk t: +44 (0)191 5000375 f: +44 (0)191 2477103 w: needaspreadsheet.com e: enquiries@needaspreadsheet.com subscribe posts atom posts all comments atom all comments simple template. powered by blogger.


Here you find all texts from your page as Google (googlebot) and others search engines seen it.

Words density analysis:

Numbers of all words: 3379

One word

Two words phrases

Three words phrases

the - 6.48% (219)
►  - 2.81% (95)
and - 2.01% (68)
for - 1.81% (61)
you - 1.66% (56)
excel - 1.63% (55)
her - 1.3% (44)
are - 1.21% (41)
criteria - 1.18% (40)
this - 1.09% (37)
that - 1.09% (37)
rank - 1.01% (34)
our - 0.92% (31)
cell - 0.89% (30)
have - 0.83% (28)
range - 0.83% (28)
number - 0.83% (28)
tip - 0.8% (27)
all - 0.74% (25)
here - 0.74% (25)
art - 0.74% (25)
post - 0.71% (24)
function - 0.71% (24)
use - 0.68% (23)
(4) - 0.65% (22)
can - 0.65% (22)
sum - 0.65% (22)
how - 0.53% (18)
return - 0.53% (18)
(1) - 0.53% (18)
count - 0.5% (17)
need - 0.5% (17)
tip: - 0.5% (17)
blog - 0.5% (17)
... - 0.5% (17)
list - 0.47% (16)
not - 0.47% (16)
date - 0.47% (16)
(5) - 0.47% (16)
numbers - 0.47% (16)
own - 0.47% (16)
day - 0.44% (15)
(2) - 0.44% (15)
sumif - 0.41% (14)
now - 0.41% (14)
will - 0.41% (14)
2016 - 0.41% (14)
work - 0.41% (14)
look - 0.38% (13)
rank. - 0.38% (13)
ref - 0.38% (13)
(3) - 0.38% (13)
get - 0.38% (13)
down - 0.38% (13)
want - 0.36% (12)
criteriarange - 0.36% (12)
sumifs - 0.36% (12)
any - 0.36% (12)
true - 0.36% (12)
other - 0.36% (12)
two - 0.36% (12)
expression - 0.33% (11)
there - 0.33% (11)
january - 0.33% (11)
december - 0.33% (11)
row - 0.33% (11)
one - 0.33% (11)
where - 0.33% (11)
which - 0.33% (11)
rank.eq - 0.33% (11)
using - 0.3% (10)
may - 0.3% (10)
formula - 0.3% (10)
free - 0.3% (10)
returns - 0.3% (10)
but - 0.3% (10)
ever - 0.3% (10)
table - 0.3% (10)
match - 0.3% (10)
with - 0.3% (10)
pro - 0.3% (10)
start - 0.3% (10)
top - 0.3% (10)
first - 0.3% (10)
posts - 0.3% (10)
100 - 0.27% (9)
fix - 0.27% (9)
column - 0.27% (9)
end - 0.27% (9)
spreadsheet - 0.24% (8)
march - 0.24% (8)
cells - 0.24% (8)
july - 0.24% (8)
same - 0.24% (8)
august - 0.24% (8)
logic - 0.24% (8)
dropdown - 0.24% (8)
refer - 0.24% (8)
your - 0.24% (8)
time - 0.24% (8)
know - 0.24% (8)
example - 0.24% (8)
when - 0.24% (8)
data - 0.24% (8)
value - 0.24% (8)
many - 0.21% (7)
september - 0.21% (7)
october - 0.21% (7)
its - 0.21% (7)
june - 0.21% (7)
feature - 0.21% (7)
has - 0.21% (7)
change - 0.21% (7)
a1=100 - 0.21% (7)
november - 0.21% (7)
add - 0.21% (7)
april - 0.21% (7)
2016, - 0.21% (7)
way - 0.21% (7)
february - 0.21% (7)
countifs - 0.18% (6)
c2:c21 - 0.18% (6)
order - 0.18% (6)
just - 0.18% (6)
format - 0.18% (6)
functions - 0.18% (6)
before - 0.18% (6)
some - 0.18% (6)
out - 0.18% (6)
part - 0.18% (6)
statement - 0.18% (6)
simple - 0.18% (6)
very - 0.18% (6)
month - 0.18% (6)
much - 0.18% (6)
glen - 0.18% (6)
feechan - 0.18% (6)
freebies - 0.18% (6)
east - 0.18% (6)
both - 0.18% (6)
comments - 0.18% (6)
subscribe - 0.18% (6)
from - 0.18% (6)
fixed - 0.15% (5)
works - 0.15% (5)
dollar - 0.15% (5)
yes - 0.15% (5)
see - 0.15% (5)
league - 0.15% (5)
mary - 0.15% (5)
real - 0.15% (5)
region - 0.15% (5)
most - 0.15% (5)
only - 0.15% (5)
criteriarange1 - 0.15% (5)
criteria1 - 0.15% (5)
ranked - 0.15% (5)
counting - 0.15% (5)
index - 0.15% (5)
rest - 0.15% (5)
multiple - 0.15% (5)
facebook - 0.15% (5)
email - 0.15% (5)
twitter - 0.15% (5)
regular - 0.15% (5)
updates - 0.15% (5)
sheets - 0.15% (5)
enter - 0.15% (5)
sign - 0.15% (5)
day, - 0.15% (5)
false - 0.15% (5)
posted - 0.15% (5)
post, - 0.15% (5)
than - 0.15% (5)
these - 0.15% (5)
expressions - 0.15% (5)
enjoyed - 0.12% (4)
(or - 0.12% (4)
would - 0.12% (4)
b2:b21 - 0.12% (4)
blog, - 0.12% (4)
"the - 0.12% (4)
features - 0.12% (4)
sarah - 0.12% (4)
know" - 0.12% (4)
"30 - 0.12% (4)
like - 0.12% (4)
allow - 0.12% (4)
often - 0.12% (4)
then - 0.12% (4)
copy - 0.12% (4)
range, - 0.12% (4)
try - 0.12% (4)
far - 0.12% (4)
over - 0.12% (4)
year - 0.12% (4)
christmas - 0.12% (4)
always - 0.12% (4)
tend - 0.12% (4)
earlier - 0.12% (4)
following - 0.12% (4)
bottom - 0.12% (4)
did - 0.12% (4)
ben - 0.12% (4)
rank) - 0.12% (4)
spreadsheet. - 0.12% (4)
chants - 0.12% (4)
even - 0.12% (4)
was - 0.12% (4)
true. - 0.12% (4)
labels: - 0.12% (4)
formatting - 0.12% (4)
north - 0.12% (4)
reference - 0.12% (4)
those - 0.12% (4)
too - 0.12% (4)
e.g. - 0.12% (4)
based - 0.12% (4)
what - 0.12% (4)
put - 0.12% (4)
particular - 0.12% (4)
logical - 0.12% (4)
a2:a21 - 0.12% (4)
follows: - 0.12% (4)
pinterest - 0.12% (4)
d2:d21, - 0.12% (4)
above - 0.12% (4)
criteria2 - 0.12% (4)
their - 0.12% (4)
criteriarange2 - 0.12% (4)
facebookshare - 0.12% (4)
thisblogthis!share - 0.12% (4)
twittershare - 0.12% (4)
better - 0.12% (4)
charts". - 0.12% (4)
rid - 0.09% (3)
make - 0.09% (3)
needaspreadsheet.com - 0.09% (3)
wish - 0.09% (3)
24s - 0.09% (3)
sumrange - 0.09% (3)
sell - 0.09% (3)
today - 0.09% (3)
(6) - 0.09% (3)
(14) - 0.09% (3)
criteria: - 0.09% (3)
signs - 0.09% (3)
second - 0.09% (3)
say - 0.09% (3)
name - 0.09% (3)
accounting - 0.09% (3)
columns - 0.09% (3)
used - 0.09% (3)
t... - 0.09% (3)
problem - 0.09% (3)
cover - 0.09% (3)
however - 0.09% (3)
text - 0.09% (3)
into - 0.09% (3)
atom - 0.09% (3)
more - 0.09% (3)
tuesday, - 0.09% (3)
argument - 0.09% (3)
c2="yes" - 0.09% (3)
in. - 0.09% (3)
excel. - 0.09% (3)
should - 0.09% (3)
populate - 0.09% (3)
empty - 0.09% (3)
particularly - 0.09% (3)
blank - 0.09% (3)
comments: - 0.09% (3)
conditional - 0.09% (3)
holiday - 0.09% (3)
true, - 0.09% (3)
2007 - 0.09% (3)
2010 - 0.09% (3)
allows - 0.09% (3)
otherwise - 0.09% (3)
three - 0.09% (3)
content - 0.09% (3)
(and - 0.09% (3)
lists - 0.09% (3)
b5<=34 - 0.09% (3)
under - 0.09% (3)
references - 0.09% (3)
training - 0.09% (3)
notice - 0.09% (3)
about - 0.09% (3)
etc. - 0.09% (3)
event - 0.09% (3)
find - 0.09% (3)
show - 0.09% (3)
hope - 0.09% (3)
word - 0.09% (3)
03:00 - 0.09% (3)
might - 0.09% (3)
1), - 0.09% (3)
(the - 0.09% (3)
here. - 0.09% (3)
negative - 0.06% (2)
working - 0.06% (2)
brackets - 0.06% (2)
family - 0.06% (2)
also - 0.06% (2)
quick - 0.06% (2)
talk - 0.06% (2)
false, - 0.06% (2)
going - 0.06% (2)
be. - 0.06% (2)
tips - 0.06% (2)
accountant - 0.06% (2)
who - 0.06% (2)
years - 0.06% (2)
clients - 0.06% (2)
tool - 0.06% (2)
powerful - 0.06% (2)
report - 0.06% (2)
every - 0.06% (2)
useful - 0.06% (2)
well - 0.06% (2)
worksheets - 0.06% (2)
found - 0.06% (2)
rather - 0.06% (2)
videos - 0.06% (2)
least - 0.06% (2)
new - 0.06% (2)
really - 0.06% (2)
workload - 0.06% (2)
merry - 0.06% (2)
ensuring - 0.06% (2)
ago - 0.06% (2)
university - 0.06% (2)
2017. - 0.06% (2)
future - 0.06% (2)
degree - 0.06% (2)
tables - 0.06% (2)
pivot - 0.06% (2)
times - 0.06% (2)
+44 - 0.06% (2)
(0)191 - 0.06% (2)
once - 0.06% (2)
answer - 0.06% (2)
seem - 0.06% (2)
(13) - 0.06% (2)
could - 0.06% (2)
across - 0.06% (2)
(for - 0.06% (2)
raise - 0.06% (2)
handle - 0.06% (2)
current - 0.06% (2)
however, - 0.06% (2)
(11) - 0.06% (2)
▼  - 0.06% (2)
events - 0.06% (2)
(8) - 0.06% (2)
value. - 0.06% (2)
select - 0.06% (2)
list, - 0.06% (2)
(19) - 0.06% (2)
validation - 0.06% (2)
matter - 0.06% (2)
is, - 0.06% (2)
rows - 0.06% (2)
mynda - 0.06% (2)
users - 0.06% (2)
today's - 0.06% (2)
point - 0.06% (2)
excellent - 0.06% (2)
webinar - 0.06% (2)
being - 0.06% (2)
same, - 0.06% (2)
adding - 0.06% (2)
dashboards - 0.06% (2)
had - 0.06% (2)
covered - 0.06% (2)
table, - 0.06% (2)
help - 0.06% (2)
been - 0.06% (2)
available - 0.06% (2)
syntax - 0.06% (2)
index/match - 0.06% (2)
does - 0.06% (2)
highest - 0.06% (2)
down, - 0.06% (2)
b3:b12 - 0.06% (2)
each - 0.06% (2)
=rank.eq($b3,$b$3:$b$12) - 0.06% (2)
instances - 0.06% (2)
gives - 0.06% (2)
similar - 0.06% (2)
left - 0.06% (2)
again - 0.06% (2)
flexible - 0.06% (2)
end, - 0.06% (2)
whereas - 0.06% (2)
24, - 0.06% (2)
counts - 0.06% (2)
far, - 0.06% (2)
so: - 0.06% (2)
essentially - 0.06% (2)
sales - 0.06% (2)
type - 0.06% (2)
run - 0.06% (2)
"north" - 0.06% (2)
places - 0.06% (2)
criteria3 - 0.06% (2)
="&date(2016,1,1)">">="&date(2016,1,1) - 0.06% (2)
"<="&date(2016,1,31) - 0.06% (2)
last - 0.06% (2)
common - 0.06% (2)
earlier, - 0.06% (2)
"east" - 0.06% (2)
calculate - 0.06% (2)
sequence - 0.06% (2)
=a1=100 - 0.06% (2)
enter: - 0.06% (2)
situations - 0.06% (2)
cells, - 0.06% (2)
doing - 0.06% (2)
"ben" - 0.06% (2)
statement, - 0.06% (2)
table. - 0.06% (2)
around - 0.06% (2)
produce - 0.06% (2)
sold - 0.06% (2)
further - 0.06% (2)
framework - 0.06% (2)
provide - 0.06% (2)
competency - 0.06% (2)
icaew - 0.06% (2)
between - 0.06% (2)
"sarah" - 0.06% (2)
please - 0.06% (2)
ranking - 0.06% (2)
examples - 0.06% (2)
upon - 0.06% (2)
expression, - 0.06% (2)
"mary" - 0.06% (2)
result - 0.06% (2)
home - 0.06% (2)
of the - 0.74% (25)
(4) ►  - 0.62% (21)
excel tip: - 0.5% (17)
(1) ►  - 0.47% (16)
(5) ►  - 0.44% (15)
(2) ►  - 0.41% (14)
in the - 0.41% (14)
(3) ►  - 0.36% (12)
to the - 0.36% (12)
at the - 0.33% (11)
the rank - 0.3% (10)
need to - 0.3% (10)
in excel - 0.3% (10)
... excel - 0.27% (9)
you can - 0.27% (9)
we are - 0.27% (9)
the top - 0.24% (8)
►  march - 0.24% (8)
►  january - 0.24% (8)
the same - 0.24% (8)
for the - 0.24% (8)
the first - 0.24% (8)
the number - 0.24% (8)
this is - 0.24% (8)
on the - 0.24% (8)
want to - 0.24% (8)
►  december - 0.24% (8)
if you - 0.24% (8)
►  june - 0.21% (7)
►  august - 0.21% (7)
we have - 0.21% (7)
►  july - 0.21% (7)
►  september - 0.21% (7)
►  november - 0.21% (7)
►  may - 0.21% (7)
►  february - 0.21% (7)
►  april - 0.21% (7)
all of - 0.21% (7)
►  october - 0.21% (7)
we can - 0.21% (7)
that i - 0.21% (7)
the list - 0.21% (7)
you need - 0.21% (7)
have a - 0.18% (6)
use the - 0.18% (6)
top of - 0.18% (6)
is the - 0.18% (6)
glen feechan - 0.18% (6)
to know - 0.18% (6)
the range - 0.18% (6)
how much - 0.18% (6)
one of - 0.18% (6)
look at - 0.18% (6)
there are - 0.15% (5)
rank.eq function - 0.15% (5)
that you - 0.15% (5)
we will - 0.15% (5)
this post, - 0.15% (5)
numbers in - 0.15% (5)
where you - 0.15% (5)
the numbers - 0.15% (5)
dropdown list - 0.15% (5)
if statement - 0.15% (5)
regular updates - 0.15% (5)
and get - 0.15% (5)
tip: a - 0.12% (4)
dollar sign - 0.12% (4)
for better - 0.12% (4)
the column - 0.12% (4)
subscribe for - 0.12% (4)
know" and - 0.12% (4)
excel features - 0.12% (4)
from the - 0.12% (4)
pinterest labels: - 0.12% (4)
facebookshare to - 0.12% (4)
criteriarange1 = - 0.12% (4)
the row - 0.12% (4)
feechan at - 0.12% (4)
. this - 0.12% (4)
have fixed - 0.12% (4)
that if - 0.12% (4)
"the 5 - 0.12% (4)
by glen - 0.12% (4)
in cell - 0.12% (4)
charts". posted - 0.12% (4)
our formula - 0.12% (4)
the rank.eq - 0.12% (4)
to add - 0.12% (4)
two freebies - 0.12% (4)
i have - 0.12% (4)
we want - 0.12% (4)
"30 chants - 0.12% (4)
twittershare to - 0.12% (4)
thisblogthis!share to - 0.12% (4)
updates and - 0.12% (4)
posted by - 0.12% (4)
better charts". - 0.12% (4)
chants for - 0.12% (4)
and "30 - 0.12% (4)
to know" - 0.12% (4)
features that - 0.12% (4)
5 excel - 0.12% (4)
freebies "the - 0.12% (4)
get two - 0.12% (4)
for regular - 0.12% (4)
email thisblogthis!share - 0.12% (4)
can subscribe - 0.12% (4)
post, go - 0.12% (4)
enjoyed this - 0.12% (4)
you enjoyed - 0.12% (4)
the bottom - 0.12% (4)
to have - 0.12% (4)
the dropdown - 0.12% (4)
is that - 0.12% (4)
the following - 0.12% (4)
start at - 0.12% (4)
february (4) - 0.12% (4)
the blog, - 0.12% (4)
to twittershare - 0.12% (4)
labels: excel - 0.12% (4)
to facebookshare - 0.12% (4)
august (2) - 0.12% (4)
a formula - 0.12% (4)
blog, where - 0.12% (4)
as follows: - 0.12% (4)
you to - 0.12% (4)
to pinterest - 0.12% (4)
bottom of - 0.09% (3)
criteriarange2 = - 0.09% (3)
you might - 0.09% (3)
are always - 0.09% (3)
can be - 0.09% (3)
march (1) - 0.09% (3)
returns true - 0.09% (3)
may (4) - 0.09% (3)
criteria1 = - 0.09% (3)
= c2:c21 - 0.09% (3)
not just - 0.09% (3)
are two - 0.09% (3)
comments: email - 0.09% (3)
to all - 0.09% (3)
criteria: criteriarange1 - 0.09% (3)
any of - 0.09% (3)
i want - 0.09% (3)
fixed the - 0.09% (3)
are true. - 0.09% (3)
blog - - 0.09% (3)
of our - 0.09% (3)
just numbers - 0.09% (3)
to change - 0.09% (3)
get the - 0.09% (3)
to refer - 0.09% (3)
dollar signs - 0.09% (3)
when you - 0.09% (3)
march (4) - 0.09% (3)
the criteria - 0.09% (3)
a cell - 0.09% (3)
allows you - 0.09% (3)
if this - 0.09% (3)
conditional formatting - 0.09% (3)
ranked in - 0.09% (3)
the if - 0.09% (3)
there is - 0.09% (3)
june (4) - 0.09% (3)
function in - 0.09% (3)
true if - 0.09% (3)
december (3) - 0.09% (3)
to populate - 0.09% (3)
a number - 0.09% (3)
at 03:00 - 0.09% (3)
we wish - 0.09% (3)
the date - 0.09% (3)
to get - 0.09% (3)
as the - 0.09% (3)
the example - 0.09% (3)
notice that - 0.09% (3)
are ranked - 0.09% (3)
way to - 0.09% (3)
to look - 0.09% (3)
we need - 0.09% (3)
to use - 0.09% (3)
but want - 0.06% (2)
sumifs can - 0.06% (2)
want it - 0.06% (2)
pivot tables - 0.06% (2)
lists start - 0.06% (2)
excel tips - 0.06% (2)
october (2) - 0.06% (2)
september (5) - 0.06% (2)
january (4) - 0.06% (2)
april (5) - 0.06% (2)
november (4) - 0.06% (2)
september (4) - 0.06% (2)
july (5) - 0.06% (2)
january (5) - 0.06% (2)
july (3) - 0.06% (2)
july (1) - 0.06% (2)
august (1) - 0.06% (2)
november (3) - 0.06% (2)
june (5) - 0.06% (2)
october (3) - 0.06% (2)
are on - 0.06% (2)
that a - 0.06% (2)
+44 (0)191 - 0.06% (2)
april (1) - 0.06% (2)
that dropdown - 0.06% (2)
excel for - 0.06% (2)
this function - 0.06% (2)
tip: the - 0.06% (2)
quick way - 0.06% (2)
negative numbers - 0.06% (2)
in brackets - 0.06% (2)
show negative - 0.06% (2)
an excel - 0.06% (2)
number of - 0.06% (2)
a quick - 0.06% (2)
tip: ensuring - 0.06% (2)
you ever - 0.06% (2)
tip: adding - 0.06% (2)
cell across - 0.06% (2)
multiple sheets - 0.06% (2)
have you - 0.06% (2)
to sum - 0.06% (2)
and an - 0.06% (2)
to handle - 0.06% (2)
column i - 0.06% (2)
our countifs - 0.06% (2)
for our - 0.06% (2)
to provide - 0.06% (2)
and no - 0.06% (2)
will look - 0.06% (2)
and allows - 0.06% (2)
the expressions - 0.06% (2)
if all - 0.06% (2)
will return - 0.06% (2)
the three - 0.06% (2)
based upon - 0.06% (2)
the content - 0.06% (2)
before i - 0.06% (2)
i hope - 0.06% (2)
expression is - 0.06% (2)
a league - 0.06% (2)
a table - 0.06% (2)
produce a - 0.06% (2)
excel 2010 - 0.06% (2)
rank function - 0.06% (2)
using excel - 0.06% (2)
function - - 0.06% (2)
number is - 0.06% (2)
of numbers - 0.06% (2)
should be - 0.06% (2)
is 100 - 0.06% (2)
return if - 0.06% (2)
are the - 0.06% (2)
match for - 0.06% (2)
ensuring that - 0.06% (2)
dropdown lists - 0.06% (2)
i start - 0.06% (2)
at least - 0.06% (2)
of data - 0.06% (2)
data validation - 0.06% (2)
the list, - 0.06% (2)
range where - 0.06% (2)
list to - 0.06% (2)
of this - 0.06% (2)
the current - 0.06% (2)
if statement, - 0.06% (2)
blank cell - 0.06% (2)
as this - 0.06% (2)
first match - 0.06% (2)
rather than - 0.06% (2)
and merry - 0.06% (2)
5 comments: - 0.06% (2)
in excel. - 0.06% (2)
cell b1 - 0.06% (2)
the word - 0.06% (2)
100 and - 0.06% (2)
numbers are - 0.06% (2)
highest rank - 0.06% (2)
no matter - 0.06% (2)
region in - 0.06% (2)
works as - 0.06% (2)
examples above - 0.06% (2)
will be - 0.06% (2)
how we - 0.06% (2)
sell in - 0.06% (2)
the east - 0.06% (2)
time we - 0.06% (2)
= b2:b21 - 0.06% (2)
criteria2 = - 0.06% (2)
the north - 0.06% (2)
the month - 0.06% (2)
as many - 0.06% (2)
this time - 0.06% (2)
= a2:a21 - 0.06% (2)
two criteria - 0.06% (2)
to make - 0.06% (2)
refer to - 0.06% (2)
date function - 0.06% (2)
criteria in - 0.06% (2)
for example - 0.06% (2)
wish to - 0.06% (2)
copy it - 0.06% (2)
the function - 0.06% (2)
month of - 0.06% (2)
in our - 0.06% (2)
returns 8 - 0.06% (2)
that we - 0.06% (2)
the references - 0.06% (2)
we copy - 0.06% (2)
so that - 0.06% (2)
number we - 0.06% (2)
two number - 0.06% (2)
the league - 0.06% (2)
range and - 0.06% (2)
the end - 0.06% (2)
24, our - 0.06% (2)
that there - 0.06% (2)
north region - 0.06% (2)
far, so: - 0.06% (2)
the second - 0.06% (2)
the result - 0.06% (2)
index and - 0.06% (2)
a real - 0.06% (2)
excel dashboards - 0.06% (2)
the other - 0.06% (2)
day that - 0.06% (2)
my most - 0.06% (2)
of excel - 0.06% (2)
all comments - 0.06% (2)
all of the - 0.21% (7)
you need to - 0.18% (6)
the top of - 0.18% (6)
top of the - 0.18% (6)
know" and "30 - 0.12% (4)
email thisblogthis!share to - 0.12% (4)
pinterest labels: excel - 0.12% (4)
2016 excel tip: - 0.12% (4)
february (4) ►  - 0.12% (4)
chants for better - 0.12% (4)
excel tip: a - 0.12% (4)
to pinterest labels: - 0.12% (4)
twittershare to facebookshare - 0.12% (4)
you enjoyed this - 0.12% (4)
glen feechan at - 0.12% (4)
charts". posted by - 0.12% (4)
thisblogthis!share to twittershare - 0.12% (4)
post, go to - 0.12% (4)
the blog, where - 0.12% (4)
you can subscribe - 0.12% (4)
for regular updates - 0.12% (4)
and get two - 0.12% (4)
freebies "the 5 - 0.12% (4)
excel features that - 0.12% (4)
to facebookshare to - 0.12% (4)
august (2) ►  - 0.12% (4)
posted by glen - 0.12% (4)
can subscribe for - 0.12% (4)
regular updates and - 0.12% (4)
get two freebies - 0.12% (4)
blog, where you - 0.12% (4)
go to the - 0.12% (4)
enjoyed this post, - 0.12% (4)
"the 5 excel - 0.12% (4)
features that you - 0.12% (4)
of the list - 0.12% (4)
need to know" - 0.12% (4)
and "30 chants - 0.12% (4)
for better charts". - 0.12% (4)
start at the - 0.09% (3)
to have a - 0.09% (3)
at the bottom - 0.09% (3)
march (4) ►  - 0.09% (3)
at the top - 0.09% (3)
one of my - 0.09% (3)
one of the - 0.09% (3)
c2:c21 criteria1 = - 0.09% (3)
criteria: criteriarange1 = - 0.09% (3)
we want to - 0.09% (3)
not just numbers - 0.09% (3)
march (1) ►  - 0.09% (3)
june (4) ►  - 0.09% (3)
may (4) ►  - 0.09% (3)
if any of - 0.09% (3)
allows you to - 0.09% (3)
the rank.eq function - 0.09% (3)
we have fixed - 0.09% (3)
have fixed the - 0.09% (3)
feechan at 03:00 - 0.09% (3)
december (3) ►  - 0.09% (3)
november (4) ►  - 0.06% (2)
october (5) ►  - 0.06% (2)
november (3) ►  - 0.06% (2)
january (4) ►  - 0.06% (2)
july (3) ►  - 0.06% (2)
may (3) ►  - 0.06% (2)
july (5) ►  - 0.06% (2)
october (3) ►  - 0.06% (2)
january (5) ►  - 0.06% (2)
way to add - 0.06% (2)
tip: a quick - 0.06% (2)
april (1) ►  - 0.06% (2)
september (5) ►  - 0.06% (2)
numbers in brackets - 0.06% (2)
negative numbers in - 0.06% (2)
october (2) ►  - 0.06% (2)
a number of - 0.06% (2)
excel tip: the - 0.06% (2)
december (2) ►  - 0.06% (2)
quick way to - 0.06% (2)
april (5) ►  - 0.06% (2)
excel tip: using - 0.06% (2)
august (1) ►  - 0.06% (2)
july (1) ►  - 0.06% (2)
same cell across - 0.06% (2)
b2:b21 criteria2 = - 0.06% (2)
it to change - 0.06% (2)
works as follows: - 0.06% (2)
the numbers are - 0.06% (2)
numbers are ranked - 0.06% (2)
the rank function - 0.06% (2)
any of the - 0.06% (2)
of the expressions - 0.06% (2)
will look at - 0.06% (2)
if expression is - 0.06% (2)
a1 is 100 - 0.06% (2)
we are always - 0.06% (2)
5 comments: email - 0.06% (2)
the first match - 0.06% (2)
have a blank - 0.06% (2)
this is to - 0.06% (2)
in excel is - 0.06% (2)
of data validation - 0.06% (2)
before i start - 0.06% (2)
dropdown lists start - 0.06% (2)
the league table - 0.06% (2)
our rank.eq function - 0.06% (2)
want it to - 0.06% (2)
in the north - 0.06% (2)
as we are - 0.06% (2)
we need to - 0.06% (2)
if we wish - 0.06% (2)
to refer to - 0.06% (2)
the criteria in - 0.06% (2)
this time we - 0.06% (2)
region in the - 0.06% (2)
tip: ensuring that - 0.06% (2)
counts that there - 0.06% (2)
the month of - 0.06% (2)
north region in - 0.06% (2)
sold in the - 0.06% (2)
in the east - 0.06% (2)
i want to - 0.06% (2)
index and match - 0.06% (2)
on the first - 0.06% (2)
so far, so: - 0.06% (2)
june (5) ►  - 0.06% (2)

Here you can find chart of all your popular one, two and three word phrases. Google and others search engines means your page is about words you use frequently.

Copyright © 2015-2016 hupso.pl. All rights reserved. FB | +G | Twitter

Hupso.pl jest serwisem internetowym, w którym jednym kliknieciem możesz szybko i łatwo sprawdź stronę www pod kątem SEO. Oferujemy darmowe pozycjonowanie stron internetowych oraz wycena domen i stron internetowych. Prowadzimy ranking polskich stron internetowych oraz ranking stron alexa.