Questions about excel-2019
Read more about excel-2019
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Is there a function for Excel 2019 like index match or vlookup to find a value in a row added cross sheet?
I am running a report on Excel 2019 which has 2 sheets, and I want to automate the value in the field called Status in the sheet2 with the new status on sheet1 where a new row was added for the same i...
David Knight
Votes: 0
Answers: 2
How can I get a named variable to evaluate in excel 2019? I want its value to change from time to time
I prefer not to use VBA (trying to keep this simple). How can I get alpha to be evaluatable in the enclosed excel snapshot? Thank you. MM
Mary A. Marion
Votes: 0
Answers: 0
Wrong nested IF formula
I use two formulas for my purpose:
In B2: If string start (begins) with substrings combination, then delete first substring
=IF(SUM(COUNTIF(A2;{"Not";"Bad"}&" "&{...
Losai
Votes: 0
Answers: 1
Combine Two Array Formulas
I have in (D2) very dirty string:
Ⱦ[ḫ]îs ɨs síṁƥḽẽ ~s?tring $with Ḑiă{cr}îtíc#s ẵɲd Ṧɏ<ṃƀǿⱡs. /123
To clean this I use two great formulas (Thanks @Jvdv)
First - Cleaning string from unwanted char...
Losai
Votes: 0
Answers: 1