tag:blogger.com,1999:blog-46899422430333599222024-09-12T21:33:31.876-07:00Excel FacileBouquinovorehttp://www.blogger.com/profile/07413791228486363596noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4689942243033359922.post-57238439525610974982012-12-05T01:34:00.002-08:002012-12-05T11:40:24.675-08:00Formule excel pour connaitre le jour exacte d'une date quelconque<br />
<div class="MsoNormal" style="text-align: justify;">
</div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Un
petit cadeau pas forcément très utile pour les fêtes de noël.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><br /></span></div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Cela
fait des années que vous cherchez à connaitre le jour de naissance de votre grand-mère
en ayant simplement sa date de naissance, mais cela vous a été impossible.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><br /></span></div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Pas
de problème, voici une petite formule simple à coller dans n’importe quelle
cellule excel.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><br /></span></div>
<div class="MsoNormal">
<b><i><span lang="FR" style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: "Georgia","serif"; font-size: 12pt; line-height: 115%;">=SI(JOURSEM(A1)=1;"Dimanche";SI(JOURSEM(A1)=2; "Lundi";SI(JOURSEM(A1)=3;"Mardi";SI(JOURSEM(A1)=4;"Mercredi";</span></i></b><br />
<b><i><span lang="FR" style="background-color: white; background-position: initial initial; background-repeat: initial initial; font-family: "Georgia","serif"; font-size: 12pt; line-height: 115%;">SI(JOURSEM(A1)=5;"Jeudi";SI(JOURSEM(A1)=6;"Vendredi";"Samedi"))))))</span></i></b><b><i><span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><o:p></o:p></span></i></b></div>
<div class="MsoNormal">
<b><i><span lang="FR" style="background: yellow; font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR; mso-highlight: yellow;"><br /></span></i></b></div>
<div class="MsoNormal">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Et
dans la cellule A1 indiquez la date qui vous intéresse sous la forme suivante
jj/mm/aaaa (au format date)<o:p></o:p></span></div>
<br />Bouquinovorehttp://www.blogger.com/profile/07413791228486363596noreply@blogger.com0tag:blogger.com,1999:blog-4689942243033359922.post-24861767112611360142012-05-11T00:38:00.000-07:002012-05-11T00:38:28.423-07:00Regrouper deux cellules<br />
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Comment
regrouper deux cellules sans perdre l’information?<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Souvent
l’on cherche à regrouper deux cellules sans perdre l’information de chacune d’elles,
mais si nous fusionnons les cellules, nous perdons une partie de l’info.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">L’idée
est donc de créer une troisième colonne qui réunit le texte des deux première. <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="FR" style="font-family: "Georgia","serif"; font-size: 12.0pt; line-height: 115%; mso-ansi-language: FR;">Ainsi
pour avoir le contenu de C1 avec le texte de A1 puis B1, nous devons inscrire
la formule suivante<o:p></o:p></span></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<b><span style="color: #070f14; font-family: "Georgia","serif"; font-size: 14.0pt; line-height: 115%; mso-bidi-font-family: "Courier New"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES;">=A1&"
"&B1<o:p></o:p></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhROT19Um4VcywKW4Yng_lSGnXutPQcev038NQlQnkj8jksSEKQAvT8zj3yqDBGimdM46xmB8NroWOC36UOHWPMBaeutV_ytJe6AqF6wZPWBugEQ9H9NV-MeyVYY9HPLiaWamE0HzVXcOg/s1600/regrouper+cellule.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="339" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhROT19Um4VcywKW4Yng_lSGnXutPQcev038NQlQnkj8jksSEKQAvT8zj3yqDBGimdM46xmB8NroWOC36UOHWPMBaeutV_ytJe6AqF6wZPWBugEQ9H9NV-MeyVYY9HPLiaWamE0HzVXcOg/s640/regrouper+cellule.JPG" width="640" /></a></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<b><span style="color: #070f14; font-family: "Georgia","serif"; font-size: 14.0pt; line-height: 115%; mso-bidi-font-family: "Courier New"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES;"><br /></span></b></div>Bouquinovorehttp://www.blogger.com/profile/07413791228486363596noreply@blogger.com0