Search results

yes it is the same like my office laptop in which I am getting the value correctly

sample file

Hi Gurus I tried one sample SCAN function formula but getting output like below please let me know where am i missing the formula

But why is not coming by default , manually formatting need to be done ? I am facing this in my personal laptop only.

I am not getting the lac indicator in sense instead of 2,45,000/- I am getting like 245,000 like to know why excel is getting defaulted like that

Hi Gurus Greetings I am using excel in which when I enter the rupee value it is not seperated with lac indicator. Pl find below screen shot , kindly guide me which setting should be changed ? The one below 2024 >> 245,400 which should be like 2,45,400. Thanks in advance. \

Sorry pl find attached.

Sample data output is like below

Hi Gurus Greetings. Formula to calculate the ticket count within a time slot. We are working based on tickets and we are able to get overall ticket count but for one MIS report they need to find out for an hour how many tickets are received per day.Kindly share inputs. Vignesh V

Dear Gurus Greetings. I need formula held in below scenario as month on month the user will add the data as shown. I am preparing a dashboard so that monthly basis I need to fetch the latest record entered by the user. seeking your help on this. Have attached the same file.

OOps sorry my bad i missed "B" will this code work in MS Office excel?

Hi Gurus Sorry If I am repeatedly posting more or less similar content. As I am inbetween a report generation this confusion.Need formula to arrive data like this table in left hand side. Sample file attached.

Thank you working now irrespective of the alphabet. You are awesome.

Modified the formula strange is when "A" is starting the series it is showing "To check" which is contradictory. Formula : =IF(INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),2))&INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),1))="0-","To Check","No Check") Reference...

Modified the formula strange is when "A" is starting the series it is showing "To check" which is contradictory. Formula : =IF(INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),2))&INDEX(B2:O2,LARGE(IF(B2:O2<>"",COLUMN(B$1:O$1)-COLUMN(A$1)),1))="0-","To Check","No Check")

Thank you. I tried with same formula copy pasted all the values from formula but observing the formula is skipping the condition.

Hi Excel Gurus I need output as mentioned in check column. Thanks

Thank you @Bosco about the special case : PartDDE will same formula work?

Hi Gurus Thanks for support regarding the post earlier done. One query is needed as below Based on the position of "-" check column data to be updated as below format. Thanks.

Thank you. Issue able to visualize as expected this worked as the data is large processing of the formula itself is taking large amount of time. Posted one more question in separate thread with same title.

Thank you but we use MS Office & not office365.

As requested new question posted.

Hi Gurus I would like to have the formula in which two set of data is needed. One is duplicate of data should be removed and data should me published. Second is Formula comparing Part no & PO columns & other with formula comparing column Part no & Price columns. Sample output shown below...

Thank you. Hope the formula you mentioned in #5 is as below Old : =IFERROR(INDEX($C$3:$D$9,AGGREGATE(15,6,ROW($B$3:$B$9)-ROW($B$2)/($G3=$B$3:$B$9)/($C$3:$C$9<>$C$4:$C$10),CEILING(COLUMNS($H3:H3)/2,1)),MOD(COLUMN(A1)+1,2)+1),"") New...

Thank you. Can I have formula only considering column B & C scenario alone ? without price column [column D].