User Profile
bbsin
Iron Contributor
Joined 5 years ago
User Widgets
Recent Discussions
conditional formula excel
Hi I have a question and need help find 3 items 1) How use conditional formula and highlight the month based on the DOB 2) How to use conditional formula to highlight in the month turn first 60 based on the birth month (eg the last row should highlight Jan - 60) Thank you Birth date Dec 23 Jan 24 Feb 24 Mar 24 Apr 24 May 24 Jun 24 Jul 24 Aug 24 Sep 24 Oct 24 Nov 24 Dec 24 3/23/1948 75 75 75 76 76 76 76 76 76 76 76 76 76 2/5/1956 67 67 68 68 68 68 68 68 68 68 68 68 68 1/31/1964 59 60 60 60 60 60 60 60 60 60 60 60 60how to match few criteria and get the result?
hi Can anyone help on the formulas I have two sheet, Sheet 1 Attendance and Sheet 2 Workshop attended How to automate the attendance to match the person email to the workshop and cohort and indicate Y attended , absent based on the data in sheet 2? If the person attendance and sheet 2 has a grey Y it should show as Y and a badge icon - replace the current tick Yes as I need to know if the badge has been awarded to him once it's completed. Can please advise? I downloaded the template fr excel temp. Attached file. Thank youSharePoint List Calendar View - help
hi I changed the SP list to view into Calendar View and I noticed that the display does not who the start time instead, it is displayed as the end time and the item Can I ask for help if it's possible to display the start to end time with the event title and some other info? eg: I like to see the below item as 12-1pm , Title, Function room name Thank youRe: dynamic excel calendar help pls
hi Rachel, Great it works. . One last question, the text are display as a string of text, is there anyway to break it into next row event -bold title confirmed XXX add Status : the data fr the list? Also anyway to color format the item by it Category? Thanks Thank youRe: dynamic excel calendar help pls
hi Rachel Thank you is there any way to auto populate the text from any other tab that match the date in the calendar? to display eg Title, Category , Start to end date / time. Attached sample tab , event data start and end time are from SP which contain Date and Time, but how to use Text Join to match it to the cal date and display across if it run few day? Thank youhow to filter the start and end date time to match date only?
hi I have a List from Sharepoint, I need to filter in Excel to display Event, LL, 20 pax confirmed like these that match the date 5 Jan to 6 Jan =FILTER(PPlan[Title],PPlan[EventStartDateTime]=F9), it show error Is there any way to display like a merge across ? Thanks
