{"id":4084,"date":"2025-03-18T10:00:00","date_gmt":"2025-03-18T10:00:00","guid":{"rendered":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/?p=4084"},"modified":"2025-02-04T09:26:50","modified_gmt":"2025-02-04T09:26:50","slug":"tipdigidol-57-cyfrif-data-penodol-yn-excel-%f0%9f%94%a2","status":"publish","type":"post","link":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/cy\/2025\/03\/18\/tipdigidol-57-cyfrif-data-penodol-yn-excel-%f0%9f%94%a2\/","title":{"rendered":"TipDigidol 57: Cyfrif Data Penodol yn Excel\u00a0\ud83d\udd22"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"3186\" height=\"750\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2024\/07\/digitips-banner_64471854.png\" alt=\"\" class=\"wp-image-3556\" \/><\/figure>\n\n\n\n<div style=\"height:19px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Ydych chi eisiau cyfrif sawl gwaith mae enw&#8217;n ymddangos mewn colofn ochr yn ochr ag amodau eraill yn Excel? Gyda TipDigidol 57 gallwn ddangos y fformiwla i chi wneud hyn.\u00a0<\/p>\n\n\n\n<p>Yn gyntaf bydd angen data tebyg i&#8217;r hyn a ddangosir yn y sgrinlun lle mae gennych chi sawl colofn o wybodaeth a lle\u2019r hoffech chi gyfrif faint o feini prawf penodol sy&#8217;n bodoli megis enwau neu ddyddiadau er enghraifft<\/p>\n\n\n\n<p>I wneud hyn bydd angen i ni ddefnyddio&#8217;r nodwedd COUNTIFS yn y tab fformiwla, dangosir hyn yn y sgrinlun isod.\u00a0\u00a0<\/p>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"592\" height=\"258\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2025\/02\/57-cy.png\" alt=\"\" class=\"wp-image-4081\" \/><\/figure>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Mae hyn yn cymryd yr ystod meini prawf sef y golofn enwau yn yr enghraifft ac yna&#8217;r meini prawf ei hun, sef yr enw Chris yn E2 yn yr enghraifft. Hefyd wedi\u2019i gynnwys yn yr enghraifft y mae ystod meini prawf arall o&#8217;r golofn o anrhegion a\u2019r meini prawf Siocled. Bydd hyn wedyn yn mynd trwy&#8217;r holl wybodaeth ac ond yn cyfrif pan fydd y ddau faen prawf hyn yn cael eu bodloni.\u00a0\u00a0<\/p>\n\n\n\n<p>Gallai hyn fod yn ddefnyddiol ar raddfa fwy ar gyfer olrhain unrhyw gyfanswm o bethau sy&#8217;n digwydd ar daenlen.\u00a0<\/p>\n\n\n\n<p class=\"has-background\" style=\"background-color:#8dd2fc73\">I ddilyn ein TipiauDigidol, tanysgrifiwch i\u2019n\u00a0<a href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/cy\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Blog Sgiliau Digidol<\/strong><\/a>. Neu, gallwch hefyd\u00a0<a href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/cy\/category\/tipiaudigi\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>ddilyn y dudalen hon<\/strong><\/a>, lle bydd TipDigidol newydd yn cael ei ychwanegu bob wythnos!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ydych chi eisiau cyfrif sawl gwaith mae enw&#8217;n ymddangos mewn colofn ochr yn ochr ag amodau eraill yn Excel? Gyda TipDigidol 57 gallwn ddangos y fformiwla i chi wneud hyn.\u00a0 Yn gyntaf bydd angen data tebyg i&#8217;r hyn a ddangosir yn y sgrinlun lle mae gennych chi sawl colofn o wybodaeth a lle\u2019r hoffech chi [&hellip;]<\/p>\n","protected":false},"author":75099,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[404,396,207],"tags":[],"class_list":["post-4084","post","type-post","status-publish","format-standard","hentry","category-cymorth-microsoft","category-microsoft-excel-cy","category-tipiaudigi"],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/4084","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/users\/75099"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/comments?post=4084"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/4084\/revisions"}],"predecessor-version":[{"id":4085,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/4084\/revisions\/4085"}],"wp:attachment":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/media?parent=4084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/categories?post=4084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/tags?post=4084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}